VLOOKUP case sensitivity

[Billy Ho]

Is there anyway to create a VLOOKUP function that is case
sensitive.

For example, right now if I compare the following values
I am returned a match:

10000000TVW & 10000000TVw

But these are 2 different values. I know I can convert
to ASCII, but is there an easier way?

thanks!

 

[Frank Kabel]

Hi
try the following array formula (entered with CTRL+SHIFT+ENTER):
=INDEX(B1:B10,MATCH(TRUE,EXACT(A1:A10,"10000000TVw"),0))

 

[Guest]

where would i put that statement within my VLOOKUP
function?

=VLOOKUP(B2,Other_Worksheet!A:E,2,FALSE)

 

[Frank Kabel]

Hi
this statements replaces your VLOOKUP statement. So in your case use
=INDEX(Other_Worksheet!B1:B1000,MATCH(TRUE,EXACT(Other_Worksheet!A1:A10
00,B2),0))

and enter this as array formula