On Apr 3, 9:55*am, carl wrote:
I just noticed that the VLOOKUP is not case sensitive.
My Data looks like this:
ColA * *ColB
JK * * *a
jk * * *b
KL * * *c
Kl * * *d
I am trying to find a formula for ColB below that produces this:
ColA * *ColB
kl * * *#N/A
KL * * *c
Kl * * *d
There are several ways to do this.. .searching this group yielded the
following results which should help you.
http://groups.google.com/group/micro...sitive+vlookup
Pierre