One way:

Array entered** :

=INDEX(G1:G6,MATCH(TRUE,EXACT(A1,F1:F6),0))

Where A1 = lookup_value
F1:G16 = lookup_table

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

--
Biff
Microsoft Excel MVP


"TISI-84601" wrote in message
...
Is there a way to perform case sensitive lookup functions? For
example...I
am trying to perform a vlookup on a cell with a value of 'dDqf'.
Unfortunately my table array contains cells in the lookup column that have
values of both 'dDqF' and 'dDqf' and the lookup function doesn't seem to
differentiate based on upper/lower case and therefore returns the 'dDqF'
value instead of the 'dDqf' value that I need it to.

Any ideas?