EQ,

Thanks for help, it is not working yet.

I use if() formula in both A1 and A2, is any incremental effort to formula
below because of it?




"E.Q." wrote:



Could it be that you need the exclamation point? If cell A1 has sheet name
and A2 has cell location try
= Indirect(A1&"!"&A2)