VLOOKUP / XLOOKUP Guide
Interactively compare VLOOKUP and XLOOKUP, and learn migration patterns.
Ad
Reference Table
| A | B | C | D | E |
|---|---|---|---|---|
| Product ID | Name | Category | Price | Stock |
| P001 | 소파 | 거실 | 500,000원 | 12 |
| P002 | 침대 | 침실 | 600,000원 | 8 |
| P003 | 책상 | 서재 | 250,000원 | 20 |
| P004 | 의자 | 서재 | 150,000원 | 35 |
| P005 | 옷장 | 침실 | 450,000원 | 6 |
Try It Yourself
VLOOKUPLegacy
=VLOOKUP("P001",A2:E6,2,FALSE)• lookup_value: the value to find
• table_array: range where col 1 is the key
• col_index_num: return column 2
• FALSE = exact match
소파
XLOOKUPModern (Microsoft 365)
=XLOOKUP("P001",A2:A6,B2:B6)• lookup_value: the value to find
• lookup_array: the column to search
• return_array: the column to return
소파
XLOOKUP Advantages
- ✓Can look left (VLOOKUP only goes right)
- ✓Uses range references instead of column numbers — survives column inserts
- ✓Built-in error handling (no IFERROR needed)
- ✓More intuitive approximate match modes
- ✓Can return multiple columns at once with an array
Ad
VLOOKUP/XLOOKUP Guide: Compare both functions in real time using sample data. Change the search value and return column to see live results, then visit the Migration tab to learn how to convert VLOOKUP formulas to XLOOKUP.