Mike...as always, you are just an Excel genius - thank you so much



"Mike H" wrote:

Hi,

One way with your lookup value in C1

=SUMPRODUCT(--(EXACT(C1,A1:A4)),B1:B4)

Mike

"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