# 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.

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))

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.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1