How do I return Last Match with VLOOKUP


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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!