If you've ever spent hours manually hunting through a massive spreadsheet to match data between two tables, you already know the pain that VLOOKUP and XLOOKUP were born to solve. These two Excel functions are arguably the most powerful tools in any analyst's or business owner's arsenal — yet they remain misunderstood, misused, and underutilized by the majority of everyday Excel users. Whether you're a complete beginner seeing =VLOOKUP for the first time or a seasoned professional looking to migrate your workflows to XLOOKUP's modern capabilities, this is the most thorough, practical guide you'll find.
1. What Is VLOOKUP — And Why Does It Matter?
VLOOKUP stands for Vertical Lookup. At its core, it is a function in Microsoft Excel (and Google Sheets) that searches a column of data for a specific value, then returns a corresponding value from another column in the same row. Think of it as your personal data detective — you give it a clue (the search value), tell it where to look (the data table), and it brings back the answer.
Here's why this matters in the real world: imagine you manage a store with thousands of products. You have one spreadsheet with product IDs and names, and another with product IDs and current stock levels. Without VLOOKUP, matching these two lists manually would take hours. With VLOOKUP, you write one formula and it completes the entire match in under a second.
VLOOKUP was introduced in Excel back in the 1980s and has remained one of the most searched Excel topics on the internet for decades. It's used by accountants, inventory managers, HR professionals, marketing analysts, teachers, and small business owners worldwide. Learning VLOOKUP is, in many professional fields, considered a foundational skill right alongside knowing how to use pivot tables.
VLOOKUP is the gateway drug to serious Excel fluency. Once you understand how lookup functions work, your entire relationship with data changes. — Common wisdom in the Excel community
That said, VLOOKUP is not perfect. It has several well-documented limitations that have frustrated data professionals for years. This is exactly why Microsoft introduced XLOOKUP in 2019 — a next-generation lookup function that solves virtually every problem VLOOKUP couldn't handle. By the end of this guide, you'll understand both intimately and know exactly when to use each.
2. Breaking Down the VLOOKUP Syntax
Before you type a single character into a cell, you need to understand what VLOOKUP is asking of you. Every Excel formula is a structured conversation, and VLOOKUP has four pieces of information (called arguments or parameters) it needs from you before it can work.
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])Understanding All Four Parameters
← Scroll table horizontally on small screens →
| Parameter | Required? | What It Means | Example |
|---|---|---|---|
lookup_value |
REQUIRED | The value you want to search for. Can be a cell reference, text string, or number. | A2 or "SKU-001" |
table_array |
REQUIRED | The range of cells containing the data. The first column of this range is where VLOOKUP searches. | B2:E100 |
col_index_num |
REQUIRED | The column number (1 = first column of the range) from which to return a value. | 3 |
[range_lookup] |
OPTIONAL | FALSE for exact match (almost always what you want). TRUE for approximate match (for sorted numerical ranges only). |
FALSE |
If you omit [range_lookup], Excel defaults to TRUE (approximate match), which can return wildly incorrect results for exact data lookups. Always explicitly type FALSE unless you specifically need an approximate match for sorted numerical ranges.
Your First VLOOKUP Formula
Let's say you have a product catalog in columns A and B, where column A has product codes and column B has product names. You want to find the name of product "SKU-042" stored in cell E2:
// Searching for the product name corresponding to the ID in cell E2
=VLOOKUP(E2, A2:B200, 2, FALSE)
// Breaking it down:
// E2 → the product code you're looking up
// A2:B200 → your product catalog table
// 2 → return the value from the 2nd column (Product Name)
// FALSE → find an exact match only3. Step-by-Step: Building VLOOKUP from Scratch
Let's walk through a concrete, hands-on example. A sales manager wants to pull employee department names from an HR table into a sales performance report.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Emp ID | Name | Department | ID (Lookup) | Dept (Result) | |
| 2 | E001 | Alice Chen | Marketing | E003 | =VLOOKUP(E2,$A$2:$C$6,3,FALSE) | |
| 3 | E002 | Bob Tran | Finance | E001 | =VLOOKUP(E3,$A$2:$C$6,3,FALSE) | |
| 4 | E003 | Sara Ali | Operations | E005 | =VLOOKUP(E4,$A$2:$C$6,3,FALSE) | |
| 5 | E004 | James Obi | Sales | |||
| 6 | E005 | Maria Lopez | Engineering |
-
Identify Your Lookup Column
The column you're searching must be the leftmost column in your
table_array. In our example, Employee IDs are in column A — so we start our range from column A. -
Define Your Table Array
Select the range that includes your lookup column plus all columns you might want to return. Press F4 to lock it as an absolute reference:
$A$2:$C$6. -
Count Your Column Index
Start counting from the first column of your table array. Column A = 1, B = 2, C = 3. We want "Department" which is the 3rd column, so we enter
3. -
Set range_lookup to FALSE
Type
FALSEor0as your fourth argument. This ensures VLOOKUP only returns an exact match — almost always what you need for data matching. -
Press Enter and Drag Down
Once your first formula works, hover over the bottom-right corner of the cell until the cursor becomes a small + crosshair, then drag down. Make sure your
table_arrayuses$locks so it doesn't shift.
4. Common VLOOKUP Errors and How to Fix Them
Errors are the most frustrating part of learning VLOOKUP — but once you understand why they appear, fixing them becomes second nature.
The #N/A Error — The Most Common Culprit
The #N/A error means "Not Available" — VLOOKUP searched the first column but couldn't find your value. The causes are surprisingly varied:
Mismatched Data Types: Your lookup value is the number 42, but the table stores it as text "42". Identical looking, but Excel treats them differently.
=VLOOKUP(TEXT(A2,"0"),…) to convert to text, or --A2 to force text-numbers to real numbers.Extra Spaces in Data: "SKU-042" and " SKU-042" (leading space) are not the same. Extremely common with imported data.
=VLOOKUP(TRIM(A2),…). Also use Find & Replace to clean the source table.Value Genuinely Doesn't Exist: Sometimes #N/A is correct — the item simply isn't in the table. The formula is working as intended.
=IFERROR(VLOOKUP(A2,$D$2:$E$100,2,FALSE),"Not Found") for a friendly message.range_lookup TRUE with Unsorted Data: When TRUE or omitted, the lookup column MUST be sorted ascending. Unsorted data returns random, incorrect results.
FALSE as your 4th argument for exact matches. Sort data ascending before using approximate match.Lookup Value Exceeds 255 Characters: Excel lookup values cannot exceed 255 characters. Longer text strings always return #N/A.
LEFT() to truncate, or restructure your data to use shorter numeric IDs instead.Lookup Column Is Not First: The target value is present in column 3 — not column 1. VLOOKUP can only search from left to right.
Other Errors You'll Encounter
Your col_index_num is greater than the number of columns in your table array. If the table is A:C (3 columns) and you request column 5, Excel has nowhere to look. Fix: recount your columns or expand your table array.
Appears when col_index_num is 0, negative, or non-numeric text. Column index must always be a positive integer ≥ 1. Check for accidentally typed letters or zeros.
The most dangerous VLOOKUP problem — wrong results with no error flag. Happens when range_lookup is TRUE with unsorted data, or when duplicates exist and VLOOKUP silently returns the first match. Always audit results against known test cases.
The Production-Grade IFERROR + VLOOKUP Pattern
// Returns blank if not found
=IFERROR(VLOOKUP(A2, $D$2:$F$500, 2, FALSE), "")
// Returns "Not Found" message if missing
=IFERROR(VLOOKUP(A2, $D$2:$F$500, 2, FALSE), "Not Found")
// Returns 0 for numeric fields to prevent sum errors
=IFERROR(VLOOKUP(A2, $D$2:$F$500, 3, FALSE), 0)5. The Limitations of VLOOKUP (Why It Breaks)
Understanding where VLOOKUP fails is just as important as knowing where it succeeds. These limitations are the direct reason Microsoft created XLOOKUP.
- Only searches left-to-right. Your search column must always be the leftmost column of your table array. You can never look "to the left."
- Column index breaks with inserted columns. If someone inserts a column into your table, your column index numbers shift and formulas silently return wrong data — a maintenance nightmare.
- Returns only the first match. When there are duplicate values in the lookup column, VLOOKUP always returns the first instance with no control over which match to use.
- No built-in "if not found" handling. Without IFERROR, unmatched lookups produce #N/A errors that disrupt downstream formulas and charts.
- Performance lag on large datasets. VLOOKUP scans from the top of a column downward. With tens of thousands of rows and hundreds of formulas, recalculations can slow noticeably.
- Cannot return multiple columns simultaneously. You must write separate VLOOKUP formulas for each column you want to return, whereas XLOOKUP can return entire arrays in one formula.
Before XLOOKUP existed, experienced Excel users bypassed VLOOKUP's left-column constraint with an INDEX(MATCH()) combination. If you're on Excel 2019 or older (where XLOOKUP isn't available), INDEX+MATCH is still the professional-grade alternative — and it works in all modern versions too.
6. Introducing XLOOKUP: The Modern Replacement
Released in August 2019 for Microsoft 365 subscribers and available in Excel 2021 and later, XLOOKUP was engineered from the ground up to address every structural weakness of VLOOKUP. It's not just an improvement — it's a complete rethink of what a lookup function should be.
XLOOKUP can search both vertically and horizontally (replacing HLOOKUP too), in any direction, with powerful built-in error handling.
🚀 Why XLOOKUP Is the Future of Excel Lookups
Microsoft's own data shows that VLOOKUP is among the top five most commonly used Excel functions globally — and also among the top sources of formula errors. XLOOKUP was built to fix this. Its design philosophy: sensible defaults that produce correct results, with optional advanced capabilities when needed.
XLOOKUP handles #N/A natively with a built-in if_not_found parameter. It returns exact matches by default without requiring FALSE. And it can search from the bottom up — something VLOOKUP was never capable of.
XLOOKUP is available in: Microsoft 365 (all plans), Excel 2021, Excel 2019 (some versions), Excel for Web, Excel for iOS/Android, and Google Sheets (added 2022). To check your Excel version: File → Account → About Excel.
7. XLOOKUP Syntax and Parameters Explained
=XLOOKUP(lookup_value, lookup_array, return_array,
[if_not_found], [match_mode], [search_mode])← Scroll table horizontally on small screens →
| Parameter | Required? | Description | Default |
|---|---|---|---|
lookup_value | REQUIRED | The value to search for (cell ref, text, number, or formula result) | — |
lookup_array | REQUIRED | The single column (or row) to search within. Completely separate from the return array. | — |
return_array | REQUIRED | The column (or row) from which to return the value. Can be to the left of the lookup array. | — |
[if_not_found] | OPTIONAL | Text or value to return if no match found. Built-in IFERROR equivalent. | #N/A |
[match_mode] | OPTIONAL | 0=exact, -1=exact or next smaller, 1=exact or next larger, 2=wildcard | 0 |
[search_mode] | OPTIONAL | 1=first to last, -1=last to first (latest match), 2=binary asc, -2=binary desc | 1 |
Unlike VLOOKUP where you specify an entire table then a column number, XLOOKUP takes the lookup column and the return column as completely separate arguments. This is what allows it to look in any direction — the return column can be anywhere in your spreadsheet, even to the left of the lookup column or on a completely different worksheet.
8. Step-by-Step: XLOOKUP in Action
Let's replicate the same employee lookup from Section 3, but using XLOOKUP:
// VLOOKUP (requires IFERROR wrapper)
=IFERROR(VLOOKUP(E2, $A$2:$C$6, 3, FALSE), "Not Found")
// XLOOKUP — cleaner, safer, more readable
=XLOOKUP(E2, $A$2:$A$6, $C$2:$C$6, "Not Found")
// E2 → look for this value
// $A$2:$A$6 → search in the Employee ID column
// $C$2:$C$6 → return from the Department column
// "Not Found" → show this if nothing matches (built-in!)Returning Multiple Columns with One XLOOKUP
// Return BOTH Name AND Department in one formula
// Spills across two adjacent cells automatically (Excel 365)
=XLOOKUP(E2, $A$2:$A$6, $B$2:$C$6, "Not Found")
// $B$2:$C$6 = 2-column array: Name + Department
// Results automatically spill into F2 and G2Searching Backward (Last Match First)
// Find the MOST RECENT entry (useful for transaction logs)
=XLOOKUP(A2, $D$2:$D$1000, $E$2:$E$1000, "No Record", 0, -1)
// search_mode -1 = search from LAST row to FIRSTWildcard Matching
// Find a product whose name CONTAINS "Wireless"
=XLOOKUP("*Wireless*", $B$2:$B$500, $C$2:$C$500, "None", 2)
// match_mode 2 = wildcard matching
// * = any characters ? = any single character9. VLOOKUP vs XLOOKUP: Head-to-Head Comparison
VLOOKUP
Legacy- Available in all Excel versions (even Excel 2003)
- Searches left-to-right only
- Requires column index number — fragile with insertions
- Defaults to approximate match (dangerous!)
- No built-in error handling — needs IFERROR
- Returns only a single column per formula
- Cannot search right-to-left
XLOOKUP
Modern- Requires Excel 2021 or Microsoft 365
- Searches in any direction (left, right, up, down)
- Uses direct column references — robust to insertions
- Defaults to exact match (safe!)
- Built-in
if_not_foundparameter - Can return multiple columns in one formula
- Supports reverse search and wildcard matching
← Scroll table horizontally on small screens →
| Feature | VLOOKUP | XLOOKUP |
|---|---|---|
| Search direction | Left-to-right only | Any direction |
| Default match type | Approximate (risky) | Exact (safe) |
| Built-in error handling | No (needs IFERROR) | Yes (if_not_found) |
| Multiple column returns | No | Yes (spill arrays) |
| Reverse search (last match) | No | Yes (search_mode=-1) |
| Robust to column insertions | No | Yes |
| Wildcard matching | Limited | Yes (match_mode=2) |
| Available in Excel 2016 | Yes | No |
| Works in Google Sheets | Yes | Yes (since 2022) |
| Replaces HLOOKUP too | No | Yes |
10. Real-World Example: Managing a Small Business Inventory
Let's bring everything together with a scenario that mirrors challenges faced by thousands of small business owners. You run an electronics shop called ClearVolt Electronics with two data tables:
- Product Master Table — SKU codes, product names, category, and supplier.
- Stock Levels Table — SKU codes, current stock quantity, reorder point, and unit cost.
Goal: create a unified inventory dashboard that pulls data from both tables.
Product Master Table (Sheet: "Products")
| A | B | C | D | |
|---|---|---|---|---|
| 1 | SKU | Product Name | Category | Supplier |
| 2 | EL-001 | Wireless Earbuds Pro | Audio | SoundCore Ltd |
| 3 | EL-002 | USB-C Fast Charger 65W | Accessories | PowerMax Inc |
| 4 | EL-003 | Smart LED Desk Lamp | Lighting | BrightCo |
| 5 | EL-004 | Bluetooth Speaker Mini | Audio | SoundCore Ltd |
| 6 | EL-005 | Laptop Stand Aluminum | Accessories | ErgoDesk |
| 7 | EL-006 | HDMI 2.1 Cable 2m | Cables | ConnectWell |
Stock Levels Table (Sheet: "Stock") — different order!
| A | B | C | D | |
|---|---|---|---|---|
| 1 | SKU | Qty in Stock | Reorder Pt | Unit Cost $ |
| 2 | EL-003 | 42 | 15 | 28.50 |
| 3 | EL-001 | 8 | 20 | 45.00 |
| 4 | EL-006 | 120 | 30 | 6.99 |
| 5 | EL-004 | 3 | 10 | 35.00 |
| 6 | EL-002 | 55 | 25 | 18.00 |
| 7 | EL-005 | 19 | 12 | 42.00 |
Dashboard Formulas (Sheet: "Dashboard")
// B2: Product Name from Products sheet
=XLOOKUP(A2, Products!$A$2:$A$7, Products!$B$2:$B$7, "Unknown")
// C2: Category
=XLOOKUP(A2, Products!$A$2:$A$7, Products!$C$2:$C$7, "N/A")
// D2: Current Stock Qty from Stock sheet
=XLOOKUP(A2, Stock!$A$2:$A$7, Stock!$B$2:$B$7, 0)
// E2: Unit Cost from Stock sheet
=XLOOKUP(A2, Stock!$A$2:$A$7, Stock!$D$2:$D$7, 0)
// F2: Reorder Alert — combining XLOOKUP with IF logic
=IF(
D2 < XLOOKUP(A2, Stock!$A$2:$A$7, Stock!$C$2:$C$7),
"⚠ REORDER NOW",
"✔ OK"
)Replace raw references like Products!$A$2:$A$7 with named ranges like ProductSKUs. Your formulas then read like English: =XLOOKUP(A2, ProductSKUs, ProductNames, "Unknown"). Set them via Formulas → Define Name.
📌 Quick Reference Cheatsheet
=VLOOKUP(val,range,col,FALSE)=IFERROR(VLOOKUP(...),"N/F")=XLOOKUP(val,src,ret,"N/F")=XLOOKUP(val,src,ret,,0,-1)=XLOOKUP("*text*",src,ret,,2)=XLOOKUP(1,(a=x)*(b=y),ret)=VLOOKUP(TRIM(UPPER(A1)),...)=XLOOKUP(A2,Table[SKU],Table[Name])11. Advanced XLOOKUP Techniques
Nested XLOOKUP (Two-Dimensional Lookup)
Look up a value at the intersection of a row and column — like a pricing matrix:
// Price matrix: rows=products, columns=customer tiers
=XLOOKUP(
"Widget A", // row lookup value
$A$2:$A$20, // product names column
XLOOKUP( // return_array = nested XLOOKUP
"Gold", // column lookup value
$B$1:$E$1, // header row of price matrix
$B$2:$E$20 // entire price data
)
)XLOOKUP with Multiple Criteria
// Method 1: Concatenate keys
=XLOOKUP(
A2&B2, // "Widget A" + "North"
$D$2:$D$500&$E$2:$E$500, // combined Product+Region lookup
$F$2:$F$500, // return Price
"Not Found"
)
// Method 2: Boolean array (more robust)
=XLOOKUP(
1, // look for TRUE
($D$2:$D$500=A2)*($E$2:$E$500=B2), // both must match
$F$2:$F$500,
"No Match"
)Approximate Match — Tax Brackets
// Income brackets in D2:D6: 0, 10000, 40000, 85000, 163300
// Rates in E2:E6: 10%, 12%, 22%, 24%, 32%
// match_mode -1 = exact or next smaller value
=XLOOKUP(
B2, // annual income e.g. $55,000
$D$2:$D$6, // bracket thresholds
$E$2:$E$6, // tax rates
"N/A",
-1 // returns 22% for $55,000 income
)12. When to Use Which Function
You're working in Excel 2016 or earlier, or sharing files with colleagues on older Excel versions. VLOOKUP is universally compatible and well understood by most Excel users, making shared workbooks easier to maintain.
You're on Microsoft 365 or Excel 2021 and working in a modern workflow. XLOOKUP should be your default choice for all new workbooks — cleaner syntax, safer defaults, built-in error handling, and flexibility make it strictly superior for the vast majority of lookup scenarios.
You need left-direction searching or robust column referencing, but must support Excel versions before 2021. INDEX+MATCH is the professional-grade pre-XLOOKUP solution and remains perfectly valid in modern Excel.
13. Pro Tips and Best Practices
Always Use Absolute References in Table Arrays
When copying VLOOKUP or XLOOKUP formulas down multiple rows, your table array reference must not shift. Press F4 after selecting your range to toggle absolute references.
// ❌ WRONG — range shifts when copied down
=XLOOKUP(A2, D2:D100, E2:E100)
// ✅ CORRECT — locked with $ signs
=XLOOKUP(A2, $D$2:$D$100, $E$2:$E$100)
// ✅ ALSO CORRECT — entire column (auto-includes new rows)
=XLOOKUP(A2, $D:$D, $E:$E) // slightly slowerUse Excel Tables (Ctrl+T) for Dynamic Ranges
Convert your data to an official Excel Table using Ctrl+T. Ranges become structured references like ProductCatalog[SKU] that automatically expand when you add rows.
// With a named Excel Table called "ProductCatalog":
=XLOOKUP(A2, ProductCatalog[SKU], ProductCatalog[Product Name], "?")
// Readable, self-documenting, auto-expandingProduction-Grade VLOOKUP with TRIM + UPPER
// Handles spaces AND case differences in one formula
=IFERROR(
VLOOKUP(TRIM(UPPER(A2)), $D$2:$F$1000, 2, FALSE),
"NOT FOUND"
)
// TRIM() removes extra spaces
// UPPER() normalizes "sku-001" and "SKU-001" to the same thingPerformance Tips for Large Datasets
- Limit your range. Use
$A$2:$C$5000instead of$A:$Cto avoid scanning entire columns. - Sort + approximate match. For approximate lookups, sorting ascending and using
TRUEtriggers a binary search instead of a linear scan — dramatically faster. - Paste as values once results are finalized to eliminate live formula overhead.
- Use XLOOKUP — its internal algorithm is optimized vs. VLOOKUP's legacy linear scan.
14. Frequently Asked Questions
Can VLOOKUP return a value to the left of the search column?
No — this is VLOOKUP's core limitation. The search column must always be the leftmost column of your table_array, and you can only retrieve values from columns to the right. Use XLOOKUP, INDEX+MATCH, or restructure your data to work around this.
Why does my VLOOKUP return the wrong value even though the data looks correct?
The most common cause is that range_lookup has been left as its default value of TRUE, triggering an approximate match on unsorted data. This silently returns the wrong result with no error message. Always add FALSE as your fourth argument. Also try wrapping your lookup value with TRIM() and CLEAN() to eliminate hidden characters.
What's the difference between XLOOKUP and INDEX+MATCH?
Both can search in any direction and handle left-lookups. XLOOKUP has cleaner, more intuitive syntax and a built-in if_not_found argument. INDEX+MATCH is available in all Excel versions including very old ones — making it the best choice for backwards compatibility. In terms of capability, XLOOKUP is slightly more powerful.
Does XLOOKUP work in Google Sheets?
Yes! Google added XLOOKUP support to Google Sheets in 2022. The syntax is identical to Excel's. VLOOKUP has been supported in Google Sheets for many years and continues to work perfectly in both platforms.
Can I use VLOOKUP / XLOOKUP across different workbooks?
Yes. Reference the external workbook in your formula: =XLOOKUP(A2,[OtherFile.xlsx]Sheet1!$A$2:$A$100,[OtherFile.xlsx]Sheet1!$B$2:$B$100,"?"). When the source workbook is closed, you'll see the full file path. Both workbooks must be accessible from the same network location.
Should I learn VLOOKUP first or go straight to XLOOKUP?
If you're on Microsoft 365 or Excel 2021, go straight to XLOOKUP — its syntax is arguably easier to learn because the safer defaults prevent the most common beginner mistakes. However, learning VLOOKUP is still valuable because you'll encounter it throughout existing workbooks in your career, and it remains necessary for users on older Excel versions.
What is the maximum number of rows VLOOKUP can handle?
Excel supports up to 1,048,576 rows per worksheet. VLOOKUP can technically scan the full column. For high-volume data (100,000+ rows), consider Power Query, Power Pivot, or structuring data as Excel Tables with XLOOKUP for significantly better performance.
15. Conclusion
You've now taken a comprehensive journey through two of Excel's most transformative functions. Let's recap what you've learned:
VLOOKUP is a battle-tested workhorse that has powered spreadsheet data analysis for four decades. Its four-parameter syntax is the foundation for understanding all lookup-based thinking in Excel. Its limitations — left-to-right only, fragile column counting, no native error handling — pushed the community toward better patterns and ultimately toward XLOOKUP.
XLOOKUP is that evolution realized. A modern, flexible, robust replacement that eliminates every major pain point while adding powerful new capabilities like multi-column returns, reverse searching, wildcard matching, and built-in error messages. If you're on Microsoft 365, there's no good reason to write a new VLOOKUP formula when XLOOKUP is available.
Through the ClearVolt Electronics inventory example, you've seen how these functions work in multi-sheet, cross-referenced business scenarios. A clean data structure + named Excel Tables + XLOOKUP formulas produces a dynamic inventory dashboard that updates automatically as your data changes.
Now apply these functions to your own work. Take a dataset you use regularly and find one opportunity to replace a manual matching task with a lookup formula. The pattern is always the same: identify your shared unique key between two tables, use it as your lookup value, and let Excel do the matching.
Continue building on this foundation with Pivot Tables, INDEX+MATCH, and Power Query — the next tier of Excel data analysis tools that will take you from spreadsheet user to data professional.
🎯 Key Takeaways
1. VLOOKUP searches the first column of a range and returns a value from a specified column to the right. Always use FALSE as the 4th argument for exact matches.
2. The most common VLOOKUP error is #N/A, usually caused by data type mismatches, extra spaces, or genuinely missing values. Wrap with IFERROR for graceful handling.
3. XLOOKUP is strictly superior for new workbooks on modern Excel: cleaner syntax, safer defaults, bidirectional search, multi-column returns, and built-in error handling.
4. Master both functions and you'll handle any lookup scenario thrown at you — in Excel, Google Sheets, or any spreadsheet platform.
Post a Comment