Bob,

Thanks for your help. It works! I think I got really confused with the
formula while I was writing it


"Bob Phillips" wrote:


How about

VLOOKUP(A1,'[Allocation Data.xls]Sheet1...


--

HTH

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


"EMarre" wrote in message
...
I need to copy a vlookup formula down a specific column. However, the
lookup_value needs to change from row to row when I copy the formula since
it
references the contents of the cells in column A. Also the contents of the
cells in column A are text not numbers therefore the INDIRECT function is
not
working for me.

Example
A B
1 ROAA010A VLOOKUP("ROAA010A",'[Allocation Data.xls]Sheet1...
2 ROAB070A VLOOKUP("ROAB070A",'[Allocation Data.xls]Sheet1...
3 ROAM050A VLOOKUP("ROAM050A",'[Allocation Data.xls]Sheet1...
. . .
. . .
. . .

Any help will be greatly appreciated.

Thanks in advance