Assuming that A2:B5 contains the lookup table, and D2 contains the
lookup value, try the following formula that needs to be confirmed with
CONTROL+SHIFT+ENTER...

=INDEX(B2:B5,MATCH(TRUE,EXACT(A2:A5,D2),0))

--
Domenic
Microsoft Excel MVP
www.xl-central.com
Your Quick Reference to Excel Solutions

In article ,
Cadders wrote:

Hi,

Is there any way that a vlookup can work correctly against a case sensitive
list please?

for example, I have a list and range like this:

list range
a 1
A 2
b 3
B 4

I am wanting to pull through the correct number in the range depending on
whether it is upper or lower case?

Thanks in advance