Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Case Sensitive Lookup

Daily Dose of Excel


  • This site is published here by kind permission of Daily Dose of Excel's owner Dick Kusleika
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
Filed under: ,
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.