vlookup - table array in cell

  • Thread starter Thread starter mino
  • Start date Start date
M

mino

Hi,

In sheets "Master" I have:
a) cell A1 with name of sheet (Ex TEST1)
b) this formula =VLOOKUP(C2,Test1!E20:H24,2,FALSE).

If I change A1 in TEST2 I need to search Vlookup in it, so the formoula
could be:
=VLOOKUP(C2,*** contents of cell A1 of sheet Master***E20:H24,2,FALSE)

I dont'f find any solution.
Anyone could help me.
tks
M
 
I'd use:

=VLOOKUP(C2,INDIRECT("'" & A1 & "'!E20:H24"),2,FALSE)

in case the worksheet name in A1 required surrounding apostrophes.
 
Back
Top