| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
INDIRECT formula not working
Hi,
What am I doing wrong here... This formuals does not work: =INDIRECT("'"&"YUNUS"&"-"&A3&"-"&B3&" "&"GD0" &"'!Q1") where A & B are cell references used in the naming of many worksheets I am attempting to obtain the value in Cell Q1 of worksheets: YUNUS-A3-B3 GD0 YUNUS-A4-B4 GD0 YUNUS-A5-B5 GD0 YUNUS-A6-B6 GD0 YUNUS-A7-B7 GD0 YUNUS-A8-B8 GD0 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
INDIRECT formula not working
On Thu, 8 Mar 2012 22:28:19 -0000, Yunus wrote:
Hi, What am I doing wrong here... This formuals does not work: =INDIRECT("'"&"YUNUS"&"-"&A3&"-"&B3&" "&"GD0" &"'!Q1") where A & B are cell references used in the naming of many worksheets I am attempting to obtain the value in Cell Q1 of worksheets: YUNUS-A3-B3 GD0 YUNUS-A4-B4 GD0 YUNUS-A5-B5 GD0 YUNUS-A6-B6 GD0 YUNUS-A7-B7 GD0 YUNUS-A8-B8 GD0 Multiposting wastes a lot of people's times. See response in other group. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Indirect formula not working if I give custom name for Sheets | Excel Discussion (Misc queries) | |||
| Indirect formula not working if I give custom name for Sheets | Excel Discussion (Misc queries) | |||
| Indirect formula not working if I give custom name for Sheets | Excel Discussion (Misc queries) | |||
| Indirect and matching formula isn't working | Excel Programming | |||
| Indirect.ext Function Isn't Working for me | Excel Programming | |||
Linear Mode
