Lookup & Reference Formulas
XLOOKUP vs VLOOKUP: Which Should You Use?
Use XLOOKUP if everyone who opens the file has Microsoft 365 or Excel 2021 or later. Otherwise use VLOOKUP with FALSE, or INDEX/MATCH. Here is how…
Lookup & Reference Formulas
XLOOKUP, VLOOKUP, INDEX/MATCH, FILTER and friends: finding and pulling data across sheets and tables.
Lookup & Reference Formulas
How to Use INDEX and MATCH Instead of VLOOKUP
A copy-ready INDEX and MATCH formula, an argument-by-argument way to convert your existing VLOOKUP, and fixes for the errors that trip people up,…
Lookup & Reference Formulas
How to Look Up a Value With Two Criteria in Excel
Need a value where two columns both match, like employee and month? Here are four working methods, from XLOOKUP to SUMIFS, with a small example you…
Lookup & Reference Formulas
How to Do a VLOOKUP to the Left (3 Working Methods)
VLOOKUP only returns values to the right of the column it searches. Here are three working ways to look left in Excel and Google Sheets, plus fixes…
Lookup & Reference Formulas
How to Pull Data From Another Sheet in Google Sheets
Use a simple tab reference for data in the same file and IMPORTRANGE for a different file. This guide maps each situation to the right formula and…