Excel
All Top 50 Excel & Business Modeling Questions#1
Mastering XLOOKUP for Exact Value Retrieval in Modern Excel
EasyDeloitteInterview Question #1
Asked at DeloitteYou are given a price table in columns A (SKU) and B (Unit Price). In cell D2, a user enters SKU 'SKU-789'. Write an XLOOKUP formula in cell E2 to fetch the corresponding unit price. Default to exact match without needing column index counts.
Input Table: ProductCatalog (A1:B5)
4 rows preview| SKU (Col A) | Unit Price (Col B) |
|---|---|
| SKU-101 | 45 |
| SKU-205 | 12.5 |
| SKU-789 | 89.99 |
| SKU-990 | 150 |
Expected Output Structure1 rows
| Search SKU (D2) | Returned Price (E2) |
|---|---|
| SKU-789 | 89.99 |
Interview Context
Asked frequently in data analyst and business analyst technical rounds. Focus on clean filtering, optimal indexing usage, and unambiguous column selection.
Microsoft Excel 365
E2fx
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | SKU (Col A) | Unit Price (Col B) | ||||
| 2 | SKU-101 | 45 | Target [Enter Formula] | |||
| 3 | SKU-205 | 12.5 | ||||
| 4 | SKU-789 | 89.99 | ||||
| 5 | SKU-990 | 150 | ||||
| 6 | ||||||
| 7 |
Click on target cell E2 and enter your formula above.Shortcut: Click "Load Solution" to inspect