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