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
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.