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
C2fx
← Swipe the sheet to see more columns →
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||||||||
| 8 | ||||||||||
| 9 | ||||||||||
| 10 |
Click on target cell C2 and enter your formula above.Shortcut: Click "Load Solution" to inspect