Kim,

Remove the + from the formula. Make sure that A1 contains the column
address (e.g.: A) and A2 contains the row address (e.g.: 1).

If the sheet is in the same workbook, you can skip the workbook name:
=INDIRECT("Detail!" & A1 & A2)
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Kim" wrote in message
ps.com...
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