View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mino[_2_] mino[_2_] is offline
external usenet poster
 
Posts: 12
Default vlookup - table array in cell

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