Look up 2 columns conditions and return 3rd column value

Tamizamuthan Vedachalam

Hello Experts,

I want to look at values from Creation Week and CR_Current Week columns and return values from CR_Start Date. I have given the lookup criteria in Column G2 and G3 and want to return the value in G4.

=INDEX(ColumnD2:ColumnD14,MATCH(IF,(ColumnG2=ColumnB2:B14)*(ColumnG3=ColumnC2:ColumnC14),0))

OR

=INDEX(ColumnD2:ColumnD14,MATCH(1,(ColumnG2=ColumnB2:B14)*(ColumnG3=ColumnC2:ColumnC14),0))

Paul Newcome

Happy to help. 👍️

Paul Newcome

You are going to want something along the lines of

=INDEX(COLLECT([CR_Start Date]:[CR_Start Date], [Creation Week]:[Creation Week], ColumnG2, [CR_Current Week]:[CR_Current Week], ColumnG3), 1)

Tamizamuthan Vedachalam

Thank you sir.. let me try this

Paul Newcome

Happy to help. 👍️