Topic

Advanced data lookup

Advanced lookup techniques for spreadsheets. INDEX/MATCH, XLOOKUP, FILTER, and multi-criteria lookups in Excel and Google Sheets.

INDEX MATCH in Google Sheets: Better Than VLOOKUP?

Learn INDEX MATCH in Google Sheets with step-by-step examples. Faster and more flexible than VLOOKUP for left lookups.

Feb 9, 20269 min read

VLOOKUP returns one result? Get multiple VLOOKUP results using FILTER, QUERY, and array formulas in Google Sheets and Excel.

Feb 8, 202613 min read

Big CSV and Excel imports freeze the tab and lose work. SmoothSheet does them server-side, with a backup you can roll back to.

See how it worksGoogle sign-in, no card. Free plan covers 10 uploads a month.