| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dynamic reference to another tab name
Currently I have a cell with this formula:
=A2 & !D6 Cell A2 contains the name of another tab in the same book and I wish to display the value from cell D6 of that sheet. Clearly the above syntax is incorrect but what should it be? Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| WEEKNUM to dynamic range name | Excel Worksheet Functions | |||
| a cell reference in a 3d reference | Excel Worksheet Functions | |||
| How to dynamically reference a dynamic named range | Excel Worksheet Functions | |||
| Dynamic reference to a sheet | Excel Worksheet Functions | |||
| Flexible Cell Reference | Excel Discussion (Misc queries) | |||
Threaded Mode
