This should work fine then

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


--
HTH

Bob Phillips

"Kay" wrote in message
...
I changed the references to cell style and now it looks like:
=VLOOKUP(D2,Lookup.xls!Unique_MPC_Unit,5,FALSE)

The data I am searching in is in the 4th column of the current sheet and I
want the results of lookup to be in the 5th column. Here is a sample of
the
current sheet:
CO UNIT ACCOUNT Unique ID MPC Unit Affiliated Unit
1 AL001 2260-0001 1AL0012260-0001 #REF! (affiliated unit is where vlookup
results should be)

This is from the lookup.xls, wyhere unique ID and MPC Unit columns are the
range named Unique_MPC_Unit:

Lawson Acct Lawson Unit Unique ID MPC Unit
1839*0000 1839*0000 HD001

Thanks for your help!
--
Kay Mejia


"Bob Phillips" wrote:

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