VLOOKUP Without Limits
Lookup across sheets, return multiple columns, and handle complex matching scenarios. Everything VLOOKUP should have been.
| A | B | C | |
|---|---|---|---|
| 1 | Lookup Value | Formula | Result |
| 2 | Product A | | — |
| 3 | Customer 123 | =UNLIMITED_VLOOKUP(A3, Customers!A:C, 3) | john@email.com |
| 4 | Order #456 | =UNLIMITED_VLOOKUP(A4, Orders!A:E, 5) | Shipped |
Lookups without limitations
All the features VLOOKUP was missing.
Cross-Sheet Lookup
Look up values across different sheets and workbooks.
Multiple Columns
Return multiple columns in a single formula.
Fuzzy Matching
Find approximate matches when exact isn't available.
Multi-Criteria
Look up using multiple conditions.
Fast Lookup
Optimized for speed on large datasets.
Error Handling
Graceful handling of missing values.
Advanced lookups in action
See how to do complex lookups easily.
=UNLIMITED_VLOOKUP(A2, Sheet2!A:D, 4, FALSE)=UNLIMITED_VLOOKUP(A2, Data!A:E, {2,3,4})=UNLIMITED_VLOOKUP(A2, Range, 2, TRUE)=V2_LOOKUP(A2, B2, Data!A:B, Data!C:C)=UNLIMITED_VLOOKUP(A2:A100, Source!A:D, 4)=UNLIMITED_VLOOKUP(A2, Inventory!A:C, 3)Frequently Asked Questions
XLOOKUP_ALL is an advanced lookup function that returns all matching values, works across sheets, and supports multiple criteria — things native VLOOKUP can't do.
VLOOKUP returns only the first match. XLOOKUP_ALL returns all matches, works in any direction, handles multiple criteria, and works across different sheets.
Yes! Reference data from other sheets in the same workbook or even from other Google Sheets files you have access to.
All matching rows are returned. You can get them as an array or choose to return specific columns from each match.
Yes! Use approximate matching for finding close matches when exact matches aren't available. Great for cleaning messy data.
Ready for better lookups?
Cross-sheet, multi-column, fuzzy matching.
Everything VLOOKUP couldn't do.
No credit card required • Cross-sheet • Multi-criteria
