Friday, January 29, 2021

Google Sheets - Lookup the Last Matching Value

If you've worked with most lookup functions (like VLOOKUP, LOOKUP, etc.) it will bring back the first matching value in the range you selected. However there may be times when you want to see the last matching value from your lookups. In this video it will go through two examples of how to get the last matching value from a lookup with Google Sheets. One will be using the LOOKUP function (along with other functions) and the other will be a crazy combination of INDEX, IF, ARRAYFORMULA, ROW AND LARGE.

No comments:

Post a Comment