| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy a formula with relative ref. keeping the same ref.? | Excel Discussion (Misc queries) | |||
| Vlookup formula Excel version 2002 | Excel Discussion (Misc queries) | |||
| IF / VLOOKUP formula won't work until saved | Excel Worksheet Functions | |||
| Display the max, then the next down, then the next down, etc. | Excel Discussion (Misc queries) | |||
| Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
Threaded Mode
