variable sheet function
Posted by Nathan on March 16, 2001 11:14 AM
In Quattro Pro you can tell the formula to use a variable sheet function that lets you use a generic formula and depending on an input from a previous cell it will go to a variable sheet. The command looks something like <sheet> in Quattro Pro. In excel the only thing that I have seen is that you can designate a specific sheet in a formula using !. Can excel do this or not?
Posted by Mark W. on March 16, 2001 12:04 PM
Nathan, this is supported by the INDIRECT()
function. For example, if cell A1 contained the
text string, "Sheet2", then =INDIRECT(A1&"!B1")
would return the value found in Sheet2!B1.
