The VLOOKUP function (and its brothers MATCH, LOOKUP, and HLOOKUP) do not care about the case of the lookup value. Take this data, for example: A
four The formula =VLOOKUP("bob",A2:B5,2,FALSE) will return “one”. It finds “Bob” and quits looking because it considers that a match.
If you need to find the true “bob”, you can use [...] Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2010/09/22/case-sensitive-lookup/
Sep 22 2010, 07:30 AM
Daily Dose of Excel