Case Sensitive LookUps

[carl]

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

 

[Pierre]

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/micr....worksheet.functions&q=case+sensitive+vlookup

Pierre