Formula to return a date when value in one sheet matches value in another.
I need a formula for if a value in Column A Sheet A matches a value in Column B Sheet B, return date from Column C Sheet B. I have been playing around with vlookup, match, and if statements and am having issues getting to format quite right.
Thank you!
Best Answer
-
Try something along the lines of
=INDEX({Sheet B Column C}, MATCH([Column A]@row, {Sheet B Column B}, 0))
Answers
-
Try something along the lines of
=INDEX({Sheet B Column C}, MATCH([Column A]@row, {Sheet B Column B}, 0))
-
That worked perfectly, thank you!
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!