Look up 2 columns conditions and return 3rd column value
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
-
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)
-
Thank you sir.. let me try this
-
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!