One way (albeit replacing vlookup with another formula)

Assume the vlookup would look like this

=VLOOKUP(A1,C2:D50,2,0)

to lookup a case sensitive string from A1 in column C and return the values
from D would be

=INDEX(D2:D50,MATCH(1,--ISNUMBER(FIND(A1,C2:C50)),0))

entered with ctrl + shift & enter



--

Regards,

Peo Sjoblom



"Dan in NY" <DaninNY@discussions.microsoft.com> wrote in message
news:EEBE086B-0A0B-4A4B-8FFC-B78BAABE606F@microsoft.com...
> I'm using vlookup for translating a code into a decode value. The codes
are
> in both lowercase and uppercase, unfortunately with the same values (e.g.,
> cnv and CNV represent 2 different things). Anyone know how to make
vlookup
> case sensitive? Or is there another fancy excel function that can provide
> the equivalent functionality?
>
> Thanks!