Cell reference within a sheet reference?!?!?!

Hi Dustin

Not too sure I understand you, but if cell A1 had the text "Sheet3" in it, then this formula would reference Cell A10 on Sheet3.

=INDIRECT(A1 & "!A10")

Dave
OzGrid Business Applications

Re: My actual scenario

Thanks for responding Dave. Nice to speak with you again. Hopefully the additional information will clear it up a bit.

Here is my actual scenario:
A B
1 Arizona =IF(ISERR(Arizona!G$8/Arizona!G$7),"",Arizona!G$8/Arizona!G$7)

2 Florida =IF(ISERR(Florida!G$8/Florida!G$7),"",Florida!G$8/Florida!G$7)

3 Texas =IF(ISERR(Texas!G$8/Texas!G$7),"",Texas!G$8/Texas!G$7)

I am trying to figure out if I can use a cell reference within a sheet reference (in column B) instead of writing out the name of the sheet (Arizona, Florida, Texas, etc - value in column A) so that I can make use of the relative cell reference when I copy the formula instead of having to rewrite or find/replace it for each section.

Similar to the following (obviously my syntax is incorrect):
A B
1 Arizona =IF(ISERR($A1)!G$8/($A1)!G$7),"",($A1)!G$8/($A1)!G$7)

2 Florida =IF(ISERR($A2)!G$8/($A2)!G$7),"",($A2)!G$8/($A2)!G$7)

3 Texas =IF(ISERR($A3)!G$8/($A3)!G$7),"",($A3)!G$8/($A3)!G$7)

Re: My actual scenario

Dustin, in this case this will work.

=IF(ISERR(INDIRECT(ADDRESS(8,7,3,,A1))/INDIRECT(ADDRESS(7,7,3,,A1))),"",INDIRECT(ADDRESS(8,7,3,,A1))/INDIRECT(ADDRESS(7,7,3,,A1)))

Dave

OzGrid Business Applications

Use this one!

=IF(ISERR(INDIRECT(ADDRESS(8,7,2,,$A1))/INDIRECT(ADDRESS(7,7,2,,$A1))),"",INDIRECT(ADDRESS(8,7,2,,$A1))/INDIRECT(ADDRESS(7,7,2,,$A1)))

Dave

OzGrid Business Applications

Thanks Dave. I'll let you know how they work...

Dustin, in this case this will work. =IF(ISERR(INDIRECT(ADDRESS(8,7,3,,A1))/INDIRECT(ADDRESS(7,7,3,,A1))),"",INDIRECT(ADDRESS(8,7,3,,A1))/INDIRECT(ADDRESS(7,7,3,,A1)))