G
Guest
I have a spreadsheet that has the same line on it, and would like to automate
a vlookup so that i do not have to change the tab name. I have the tab names
in a column already, before that cell I was making the range with a formula
so that I coudl reference that cell to define my range. That does not seem
to be working, does anyone know how to work around that? Example below
Formula that works
=VLOOKUP("a",Sheet2!1:65536,2,FALSE)
Formula that does not work
A1 = Sheet2!1:65536
=VLOOKUP("a",A1,2,FALSE)
a vlookup so that i do not have to change the tab name. I have the tab names
in a column already, before that cell I was making the range with a formula
so that I coudl reference that cell to define my range. That does not seem
to be working, does anyone know how to work around that? Example below
Formula that works
=VLOOKUP("a",Sheet2!1:65536,2,FALSE)
Formula that does not work
A1 = Sheet2!1:65536
=VLOOKUP("a",A1,2,FALSE)