How do I set up vlookup so that it is case sensitive?

[Oliver Madden]

Hello.

I am using the vlookup function and have a table which uses currency codes -
some are in main currency others are in the small denomination - for example
GBP and GBp. The problem is when I use vlookup to reference the table it
doesn't differentiate between the two.

Can anyone help me so that I can set it up so it reads different values?

Kind regards
Oliver

 

[Bernard Liengme]

A1:A12 has text including GBP and GBp
B1:B12 has numbers
E1 has the text to look up (say, GBP)
Formal to do exact lookup
=SUMPRODUCT(--(EXACT(E1,A1:A12)),B1:B12)
This assumes that each text item is unique in A1:A12
best wishes