vlookup - table array in cell

[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

 

[Mike H]

Try this

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

With yoyr workshet name in A1

Mike

 

[mino]

Mike,
it works.

many Thanks

Try this

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

With yoyr workshet name in A1

Mike

 

[Dave Peterson]

I'd use:

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

in case the worksheet name in A1 required surrounding apostrophes.