Or the more robust
=INDIRECT("Sheet3!"&CELL("address",B9))
--
Regards,
Peo Sjoblom
http://nwexcelsolutions.com
that way you won't get an erroneous result if there is a row inserted above
the formula
"Brian Taylor" wrote in message
oups.com...
The only bummer about that is that you can't drag down the formula and
have it stay relative (B9,B10,B1,etc.) If you have a spreadsheet that
is hundreds of rows long that is a REAL bummer. Sometimes when working
with Indirects to get around this I also use the row() and column()
functions so you can drag it still. Something like:
=Indirect("Sheet3!B" & row())
Or row plus some amount if you need to tweak it.