Thank-you, Ken. Column reference was the last thing wrong and it's all good
now.
--
Kay Mejia


"Ken Wright" wrote:

Your formula should look like this:-

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

What this will do is to take the value that is in D2 in your current
workbook, then go to your named range in the file Lookup.xls and look for
that value in the leftmost column of your range (This is column 1 of your
range, regardless of which column it is, eg A, B, C...). When it finds it
it will return the corresponding value from the column to the right of where
it finds the value (From your text I would say this is column 2, hence the 2
in the formula).

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------Â*------------------------------Â*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------Â*------------------------------Â*----------------



"Kay" wrote in message
...
Do I have this backward? I need to find the value located in the
lookup_value by searching in the table_array, returning the 2nd column
from
the array to the column in the col_index_num location.
--
Kay Mejia


"Kay" wrote:

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