# how to make MATCH and VLOOKUP case-sensitive

1. ## how to make MATCH and VLOOKUP case-sensitive

Hello

Is there any way to make MATCH and VLOOKUP case-sensitive?

For example, I want VLOOKUP to look up "art" and not "Art" in a column.  Register To Reply

2. ## Re: how to make MATCH and VLOOKUP case-sensitive

There are a few approaches - assume lookup values in A with values to be returned in B ... criteria is in C1 with result formula in D1:

D1: =INDEX(B1:B100,MATCH(TRUE,INDEX(EXACT(A1:A100,C1),0),0))  Register To Reply

3. ## Re: how to make MATCH and VLOOKUP case-sensitive

Try this

=IF(EXACT(E2,VLOOKUP(E2,Buildings!\$E:\$E,1,FALSE)),VLOOKUP(E2,Buildings!\$E:\$E,2,FALSE),"No Exact Match"

Basically you are writing the formula to find the Exact match first in column(1). If an exact match is found then Vlookup and place the contents of coulumn (2). If match found but not exact place "No Exact Match" in the cell.

Note if there is nothing found at all in the range the result in cell will be #N/A.  Register To Reply