VLOOKUP with case sensitive

  • Thread starter Thread starter James
  • Start date Start date
J

James

Hello,

I'm trying to run a VLookup with account IDs, the problem is I may have two
that are the same but in different cases :

00100000002s74J
00100000002S74j

Is it possible to distinguish between these two in the Vlookup?

Thanks very much for your help,

James
 
Hi James
try the following array formula (enetred with CTRL+SHIFT+ENTER):
=INDEX(B1:B100,MATCH(TRUE,EXACT(A1:A100,"00100000002s74J"),0))

to return the value from column B
 
Hi Frank,

thanks very much for your reply. The problem is I can have many account IDs
that are the same but are case sensitive. Is it possible to concatenate
VLOOKUP with EXACT for example?

Thanks again,

James
 
Hi James
the formula below should do this (I replaced VLOOKUP with a combination
of MATCH and INDEX). This formula is case sensitive. Of course you can
replace the hard-coded lookup criteria "00100000002s74J" with a cell
reference.
Assumption I made:
- column A contains the account IDs.
- column B the value you want returned

So did you try the formula or do you encounter problems with that
approach? And if yes which problems?
You may also explain your spreadsheet layout a little bit more to get a
more custom tailored answer :-)
 
Back
Top