| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using the name of a worksheet written in a cell, inside a formula
How can I use the name of a worksheet written in a cell, inside a formula
(VLOOKUP/HLOOKUP). Ex. Cell A1 = BalanceSheet1 =HLOOKUP('General Fund'!G$1,Sheet1!$B$4:$CM$4,1,FALSE) How to replace Sheet1 with the contents of Cell A1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Identify if Cell is Formula or written number | Excel Worksheet Functions | |||
| Worksheet name / reference as a formula? | Excel Discussion (Misc queries) | |||
| Adding the contents of a cell to a formula | Excel Discussion (Misc queries) | |||
| Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
