Look up 2 columns conditions and return 3rd column value

Options

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))


Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!