Excel Guides

Making VLOOKUP Case Sensitive in Excel

If you're looking to make your VLOOKUP function case sensitive in Excel, there are a few things you can do. First, you can use the EXACT function. This will return TRUE if the two values being compared are exactly the same, including case. So, if you have a value in cell A1 and you're looking up that value in column B, you can use the following formula:

=EXACT(A1,VLOOKUP(A1,B:B,1,FALSE))

If this formula returns TRUE, it means that the value in A1 was found in column B and that the cases match. If it returns FALSE, it means either the value wasn't found or the cases don't match.

Another option is to use the INDEX and MATCH functions. These two functions work together to perform a lookup based on a given criteria. In this case, we want to look up a value based on whether or not the case matches. To do this, we'll use an array formula that looks like this:

=INDEX(B:B,MATCH(1,--EXACT(A1,B:B),0))

This formula will return the value in column B that matches the value in A1 exactly, including case. If no match is found, it will return #N/A.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.