Wednesday, January 20, 2021

Google Sheets - Perform a Lookup [3 Examples]

In most spreadsheet applications there are multiple ways to do the same thing. Google sheets is not exception as it provides you many ways to accomplish similar tasks. A common task in most spreadsheets is looking up values or records based on set criteria. There are a few functions we can use in Google Sheets to do a lookup and this video will cover three functions that can accomplish lookups: VLOOKUP, the INDEX / MATCH combination and FILTER (though the FILTER function is not technically a lookup function it can still be used to lookup records).

No comments:

Post a Comment