Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Vlookup won't work, any other ideas?
Hello all, I have a problem and I hope you can help me solve it.
I am creating an excel spread sheet to collect data from other sheets and compare them. I want this sheet to be as automated as possible so that anyone can use it. There is a new source sheet created every week. My idea was to have a cell on the main sheet to input the file name of the new sheet above every column, and then have something like vlookup use that cell as a reference to collect the data. This won't work as vlookup won't resolve the link to the reference cell, so all I get is #N/A. Does anyone have any other ideas. TIS Huw Thomas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Nested if, sum & vlookup Function | Excel Worksheet Functions | |||
VLOOKUP won't work | Excel Worksheet Functions | |||
Assign Macro to button in Excel doesnt work Any ideas? | Excel Discussion (Misc queries) | |||
formula from Excel97 doesn't work in Excel2003,any ideas why? | Excel Worksheet Functions |