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