Case Sensitive Vlookup

**VegasL** · 05-25-2010, 12:26 PM

Hello,

I am trying to make this formula case sensitve vlookup.

IF(ISNA(VLOOKUP(B3,$A:$A,1,FALSE)),B3,"").

Any help would be appreciated?

Using excel 2007

Thanks

**NBVC** · 05-25-2010, 12:34 PM

You mean?

=IF(ISNA(VLOOKUP(B3,$A:$A,1,FALSE)),"",IF(EXACT(B3,VLOOKUP(B3,$A:$A,1,FALSE)),B3,""))

**contaminated** · 05-25-2010, 12:41 PM

U can use this array function
=INDEX(B2:B10,MATCH(TRUE,EXACT(D4,A2:A10),0))

see attachement

**NBVC** · 05-25-2010, 12:49 PM

Or non-array entered:

=INDEX(A2:A10,MATCH(TRUE,INDEX(EXACT(B3,A2:A10),0),0))

where you are only checking that the value in B3 exists exactly as is written in B3 within A1:A10....

**day92** · 05-25-2010, 01:20 PM

Or you can use this non array IF statement. Take your pick!

=IF(ISNA(MATCH(TRUE,INDEX(EXACT(D4,A2:A10),,1),0)),"",INDEX(B2:B10,MATCH(TRUE,INDEX(EXACT(D4,A2:A10),,1),0)))