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