How do I populate a worksheet name in a formula using a cell ref.
 

I would like a worksheet to populate from another worksheet of my choosing by
entering the worksheet name I wish to use in a cell and referencing it in an
"if" formula. I can't seem to find a way to reference cell A1 as a worksheet
name without A1! showing up as the reference. Any ideas?

How do I populate a worksheet name in a formula using a cell ref.
 

lookup the Indirect formula in the funciton wizard. This may do what you want.

"Badger" wrote:

I would like a worksheet to populate from another worksheet of my choosing by
entering the worksheet name I wish to use in a cell and referencing it in an
"if" formula. I can't seem to find a way to reference cell A1 as a worksheet
name without A1! showing up as the reference. Any ideas?