Copy VLOOKUP Formula
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
|