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…
Practical spreadsheet formulas and templates for everyday work
Cellwise explains spreadsheet formulas in plain English and offers copy-ready templates for Excel and Google Sheets, so you can finish everyday work tasks faster and with fewer errors.
Latest articles
All articles
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…
Browse by topic
- Lookup & Reference FormulasXLOOKUP, VLOOKUP, INDEX/MATCH, FILTER and friends: finding and pulling data across… · 5 articles
- Dates, Times & SchedulesWorking with dates, durations, deadlines, workdays, age, and shift or project timelines. · 0 articles
- Text & Data CleanupSplitting, combining, trimming and standardizing messy text, names, emails and imported… · 0 articles
- Logic, Math & Conditional FormulasIF, IFS, SUMIFS, COUNTIFS, rounding, percentages and conditional calculations for reports. · 0 articles
- Templates for WorkStep-by-step builds of budgets, trackers, timesheets, invoices, inventory lists and… · 0 articles
- Errors & TroubleshootingDecoding #N/A, #VALUE!, #REF!, numbers stored as text, and other common spreadsheet… · 0 articles