How to Do a VLOOKUP in Google Sheets
VLOOKUP in Google Sheets, with the exact syntax and a working example. Plus how to pull from another sheet, fix #N/A, and when to use XLOOKUP instead.
3 min read
#Formulas
Everything tagged Formulas.
4 articles
How to Use INDEX MATCH in Excel
INDEX MATCH is Excel's flexible lookup: MATCH finds the row, INDEX returns the value. Learn the formula, the match_type rules, and error handling.
3 min read
How to Compare Two Columns in Excel to Find Matches
Compare two Excel columns for matches or differences using Conditional Formatting, a simple formula flag, COUNTIF or MATCH, and Go To Special row differences.
6 min read
How to use AI in Excel with Copilot and Analyze Data
Three ways to use AI in Excel: paid Copilot writes formulas and analyzes data, free Analyze Data finds trends, and ChatGPT explains any formula.
8 min read