View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Yunus Yunus is offline
external usenet poster
 
Posts: 22
Default 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