Hello,

I am trying to find a case sensitve v-lookup. I used the following vlookup
but found it returned incorrect data because it is not case sensitve.
=VLOOKUP(E2,Sheet2!$A$2:$B$591,2)

Here is an example of my data range and the
Col A(table array) Col B (table array) Col D (v-lookup) Col E
(lookup value)
AK99 AKG THERMAL AIRMITE AF99
ak99 ALKON AIRMITE af99
AN99 ANDERSON ALKON AK99
an99 ALLIED W ALKON ak99
AF10 ANCHOR FLUID PW ALLIED W AN99
af10 AIRMITE PRESSES ALLIED W an99


I tried the following
=IF(EXACT(E2,VLOOKUP(E2,Sheet2!$A$2:$B$591,1,FALSE ))=TRUE,VLOOKUP(E2,Sheet2!$A$2:$B$591,2,FALSE),"No exact match") it returned N/A.

Any suggestions?

Thanks in advance for your help.

Lee