Tom’s Tutorials For Excel: Case Sensitive LOOKUP

Here’s how you can attack a lookup action for a unique list of items, when the only difference among the characters in the list is their upper or lower case.







The criteria item to lookup is in blue-colored cell D5.

The formula in the pink-colored cell E5 is

=INDEX(B5:B20,MATCH(TRUE,EXACT(D5,A5:A20),0)) .

This is an array formula. Array formulas are entered by simultaneously pressing the Ctrl+Shift+Enter keys. The curly braces are not entered by you; Excel places them automatically when the array formula is properly entered.