Dear all,
I need vlookup statment case sensitive - Please help me.
I have excel file like
in Sheet1
a small
A big
w small
W big
Q big
s small

and sheet2 have
a
A
w
W
q
q
s
Q

i want to fill column B (in sheet2) using vlookup with sheet1.

I had used
=IF(EXACT(A1,VLOOKUP(A1,Sheet2!A:B,1,0)),VLOOKUP(A1,Sheet2!A:B,2,0),"No Exact Match")
but it's not working perfect.

Any idea?

Regards
Vinay