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

vlookup - table array in cell
 

Try this

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

With yoyr workshet name in A1

Mike

"mino" wrote:

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

vlookup - table array in cell
 

Mike,
it works.

many Thanks

"Mike H" ha scritto nel messaggio
...
Try this

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

With yoyr workshet name in A1

Mike

"mino" wrote:

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

vlookup - table array in cell
 

I'd use:

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

in case the worksheet name in A1 required surrounding apostrophes.

mino wrote:

Mike,
it works.

many Thanks

"Mike H" ha scritto nel messaggio
...
Try this

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

With yoyr workshet name in A1

Mike

"mino" wrote:

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




--

Dave Peterson