software

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
quot;ifquot; 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?

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

quot;Badgerquot; wrote:

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