Look in the help index for EXACT

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Cadders" wrote in message
...
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