indirect

  • Thread starter Thread starter scottwilsonx
  • Start date Start date
S

scottwilsonx

Hope someone can help with this query.

I have an INDIRECT function which checks the worksheet name and return
the value of a specified cell from the appropriate worksheet. Thi
work perfectly. But is it possible to include 2 positions in the sam
INDIRECT function.
For example, an INDIRECT that takes values from a location based on
criteria.

Thanks for your help/

Scott
 
Hi
maybe something like
=INDIRECT("'sheet1'!" & A1+B1)

You may provide some more details what you're trying to do exactly
 
Hi, detailed example below:
Each worksheet is named after a month, eg: June 2003, and in th
worksheet: A10 to E10 will relate to a specific value each.
With cells A9: E9 showing the Headers, eg: sales, turnover etc.
and cells A8 to E8 relating to individual months.
The INDIRECT formula I have at present is:
=INDIRECT("'" &A8 & "'!e10") which will return the value in cell E1
for the month month as specified in cell A8. For example chage A8 t
May 2003 and it will look up worksheet May 2003 and return cell E10.

What I would like is the same sort of formula, but one which will als
allow me to change the A10 to E10 section and not just E10 which at th
moment is a total.

Thanks.
Scott
 
Back
Top