VLOOKUP case-sensitive

[spidery6]

Is there any way of doing a case-sensitive VLOOKUP?

If my lookup table_array (A1:B2) contains
APPLES xxx
apples yyy
then VLOOKUP("apples",A1:B2,2,false) returns "xxx", but I want "yyy".

 

[Domenic]

Try...

=INDEX(B1:B2,MATCH(TRUE,EXACT(A1:A2,"apples"),0))

...confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

 

[Aladin Akyurek]

Also...

=LOOKUP(9.99999999999999E+307,FIND("apples",$A$1:$A$2),$B$1:$B$2)

 

[spidery6]

Aladin - I like your method - thank you. Dominic's version works too, but I don't like using array formulas if there's an alternative.