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

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

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

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


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