M
martinbr
I'm trying to create a vlookup worksheet template.
I would like to reference the value of cell A1 as the 2nd argumen
(table_array) in the function.
Cell A1 would contain the full path, worksheet name, and sheet name o
the worksheet.
For example, cell A1 would be : f:\finance\[October]Revenue!. Th
lookup range would be the same in all of the worksheets ($A$1:$B$1)
=VLOOKUP(1,&A1&!$A$1:$B$1,2) does not work.
Thanks in advance
I would like to reference the value of cell A1 as the 2nd argumen
(table_array) in the function.
Cell A1 would contain the full path, worksheet name, and sheet name o
the worksheet.
For example, cell A1 would be : f:\finance\[October]Revenue!. Th
lookup range would be the same in all of the worksheets ($A$1:$B$1)
=VLOOKUP(1,&A1&!$A$1:$B$1,2) does not work.
Thanks in advance