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
Loading comments…