Why are you using R1C1 style not A1

=VLOOKUP(D2,Lookup.xls!Unique_MPC_Unit,5,FALSE)

I cannot see variable widths being the issue, but perhaps you could post
some data.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Kay" wrote in message
...
My data has 3 columns that id a value. I have concatenated them to create
a
unique ID. In the lookup.xls I created a map for each unique ID to the
desired output text. The uniqueID is in col 4, row2; the range that
contains
my mapping (unique ID in left column, sorted ascending, and text to
assign/retrieve in next column) is in the lookup.xls as a range named
Unique_MPC_Unit. I cannot get this to work. Is it because the all my
columns contain text of variable widths?

=VLOOKUP(RC[-1],Lookup.xls!Unique_MPC_Unit,5,FALSE)
--
Kay Mejia