Lookups
VLOOKUP, XLOOKUP, INDEX MATCH and FILTER in Google Sheets: several conditions, several columns, the last match and the mistakes that return a wrong value, all tested.
-
XLOOKUP Returning Multiple Columns in Google Sheets
One XLOOKUP can bring back a whole row of results instead of a single cell. You don’t need one formula per column: give XLOOKUP a result range that is several…
-
XLOOKUP with Multiple Criteria in Google Sheets (and Why It Needs ARRAYFORMULA)
XLOOKUP searches one column. To find a row that matches two or three conditions at once, such as a region and a product, you turn the conditions into a single…
-
VLOOKUP vs XLOOKUP vs INDEX MATCH in Google Sheets: 10 Tests
Google Sheets has three common ways to look up a value: VLOOKUP, XLOOKUP and INDEX with MATCH. All three find “Cherry” and return its units. They differ in what happens…