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.
