How do I return Last Match with VLOOKUP
Hello,
My VLOOKUP function is always returning the first match other than the last match.
The lookup table is updated chronologically, and I need to return the most recent data which will always be the last match.
I'm open to other solutions that use other functions.
Thanks.
Answers
-
I'd suggest use using some MAX/COLLECT formula instead of VLOOKUP in your case.
Hope it helped!
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!