Vlookup Case sensitive

**Ron Coderre** · 10-16-2008, 10:33 AM

With
Sheet2 containing this list in A1:B6

a	small
A	big
w	small
W	big
Q	big
s	small

and...Sheet1 containing this list in A1:A8

a
A
w
W
q
q
s
Q

This formula returns the category (from Sheet2) that corresponds
to the letter in Col_A

B1: =IF(ISNUMBER(MATCH(1,INDEX(--EXACT(A1,
Sheet2!$A$1:$A$6),0),0)),MATCH(1,INDEX(--EXACT(
A1,Sheet2!$A$1:$A$6),0),0),"No Match")

Copy that formula down through B8.

Is that something you can work with?

**martindwilson** · 10-16-2008, 10:42 AM

if as in your example its only one letter and you want to return upper and lower case matches use a helper column in front of your data on sheet 1
with =code(b1) dragged down where col b is list of letters in upper/lower
and col c is big,small
then on sheet 2 col b use
=VLOOKUP(CODE(A1),Sheet1!A1:C100,3,FALSE)