If a Name on Sheet A is also on Sheet B then return the date associated with name on Sheet B
Options
Best Answer
-
You would need a standard INDEX/MATCH.
=INDEX({Sheet B Date}, MATCH([Name Column]@row, {Sheet B Name}, 0))
Answers
-
You would need a standard INDEX/MATCH.
=INDEX({Sheet B Date}, MATCH([Name Column]@row, {Sheet B Name}, 0))
-
Excellent! Thank you for the quick response. I appreciate it.
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!