If it's in the same file, don't put in the workbook name (and don't for
whatever reason, use "+" as a prefix):

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


In article om,
"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