Multi-column Excel lookups in one line - using plain English
If you spend any real time wrestling with VLOOKUP or XLOOKUP, we think this is worth 30 seconds of your attention.
We created Excelerate®, and one of the features we're most proud of is the lookup tool. Instead of writing formulas, you type a plain English command and it handles table-to-table lookups for you.
Here's what it actually does:
- Searches an entire list of entries across any column at once
- Returns first match, last match, or all matches...your call
- Handles approximate matching, wildcards (?, *), and numerical operators (<, >=, etc.)
- Searches across multiple columns and multiple tables simultaneously in a single command
- Set it up once, rerun whenever your data updates
- All actions are documented in plain readable text, so auditing or making changes is easy
No more pasting data into one massive sheet. No more formula spaghetti.
We put together a short demo if you want to see it in action: https://vimeo.com/1165203634
Happy to answer questions in the comments.
Posted Feb 19, 2026, 3:50 PM UTC
00