| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup , Referencing a cell to refence table array | Excel Worksheet Functions | |||
| Replacing a Table-array with a cell reference in vlookup | Excel Worksheet Functions | |||
| use cell reference,whose contents= a table array name for Vlookup | Excel Worksheet Functions | |||
| How to use a cell value as Table Array in VLOOKUP worksheet function | Excel Discussion (Misc queries) | |||
| Vlookup, table array is referenced in another cell | Excel Programming | |||
![mino[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
