A
Ariel
I am trying to write a vlookup function with the table array in the second argument refers to a cell which indicates what worksheet and cell range to look for. In other words, I'd like to write a function that looks something like: vlookup(A1, B1, 1, false) where cell B1 contains: [Book2]Sheet1!$B$3:$F$1
I tried to accomplish this using the indirect function: =vlookup(A1, indirect(B1), 1, false) but this only works when the linked worksheet is open and I want to be able to accomplish this when the linked worksheet is closed as well. Does anyone have any ideas? Can it be done without VBA? If VBA is the only option what's the correct syntax?
I tried to accomplish this using the indirect function: =vlookup(A1, indirect(B1), 1, false) but this only works when the linked worksheet is open and I want to be able to accomplish this when the linked worksheet is closed as well. Does anyone have any ideas? Can it be done without VBA? If VBA is the only option what's the correct syntax?