Case Sensitive Vlookup

Hey yall,

I am having a problem where vlookup will pull the wrong account number because some are "123a" and others are "123A" and it will not differentiate. Any ideas? I don't know if vlookup can do this or not.

I attached an example where I know account number, phone, and contact. But it is pulling the wrong info over because it will not do an exact match. Any ideas? Thanks so much for the help!

You want to seriously consider changing your account numbering system.
Excel and many other programes see "123a" and "123A" as the same thing, maybe because it is a common typing error.
Many formulae are not case-sensitive, so you are only inviting trouble.
There are some that are case-sensitive, FIND() springs to mind, but finding workarounds for a bad system is not the best approach.

Hi Dawgin, try this array formula (must be confirmed with CTRL+SHIFT+ENTER, not just ENTER):

=INDEX($B$3:$B$6,MATCH(TRUE,EXACT(F3,$A$3:$A$6),0))

Hope that helps!

Here's another approach, but Pauls' is better.