Excel
All Top 50 Excel & Business Modeling Questions#28
Enforcing Case-Sensitive Lookups and Text Comparisons with EXACT
EasyAmazonInterview Question #28
Asked at AmazonIn Excel, `="ABC"="abc"` returns TRUE because Excel's default operators are case-insensitive. In cell `A2` you have SKU 'PROD-x' and in `B2` you have 'PROD-X'. Write a formula in `C2` that returns TRUE only if the two strings match with exact case sensitivity.
Input Table: SKUValidation (A1:B3)
2 rows preview| Input Code (Col A) | Master Code (Col B) |
|---|---|
| PROD-x | PROD-X |
| KEY-99 | KEY-99 |
Expected Output Structure2 rows
| Exact Match (Col C) |
|---|
| false |
| true |
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 | Input Code (Col A) | Master Code (Col B) | ||||
| 2 | PROD-x | PROD-X | Target [Enter Formula] | |||
| 3 | KEY-99 | KEY-99 | ||||
| 4 | ||||||
| 5 | ||||||
| 6 | ||||||
| 7 |
Click on target cell E2 and enter your formula above.Shortcut: Click "Load Solution" to inspect