And just to add...

If your worksheet needs apostrophes surrounding it (when it has spaces in the
name):

=INDIRECT("'Detail 999'!"&A1&A2)

And =indirect() won't work if the other sheet is in another workbook and that
other workbook is closed.

It'll work if that other workbook is open, though.



Kim wrote:

Hi,

I use the INDIRECT function to access data in the one sheet
successfully but when I try to access data in the same file but on
another sheet tab, I get the REF! error.

Can anyone assist with this?

Typically my command is of the natu

=INDIRECT("+'[source data workbook.xls]Detail'!"&$A$1&$A$2)

but results in an error.

Thanks guys,

Kim

--

Dave Peterson