G

#### Gemi

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