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

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