INDIRECT formula not working

Y

Yunus

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
 
R

Ron Rosenfeld

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
Click to expand...

Multiposting wastes a lot of people's times. See response in other group.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

INDIRECT formula not working 8
Alpha sorting (with a twist...?) 3
PLEASE HELP TO MATCH ALL SHEET AND THEN MERGE, 1
sumif 9
find blank cell and replace with " ' " 2
conditional sum? 2
INDIRECT Formula 3
Linking Drop Down Box 1

Top