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
B 1
Name
Number 2
Bob
one 3
Jim
two 4
bob
three 5
jim
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/
Posted
Sep 22 2010, 07:30 AM
by
Daily Dose of Excel