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!