ExcelBanter - INDIRECT formula not working

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - INDIRECT formula not working (https://www.excelbanter.com/excel-discussion-misc-queries/437832-indirect-formula-not-working.html)

Yunus

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

Ron Rosenfeld[_2_]

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.

All times are GMT +1. The time now is 09:20 AM.