=Indirect() expects something that looks like a range address/range name in that
cell.

So if A3 contained X99, then
=indirect(a3)
would return the value contained in X99.



Julie L wrote:

Hi,

I tried to use the indirect function (i.e. indirect(A3)) where A3 contains a
number (say 3), but the result came back as #REF. Any idea what caused the
problem.

Thanks,
Jules

--

Dave Peterson