R
robot
Hi,
I need a formula that references a cell (say C2) of one of the worksheets
called U3, U4, V3, V4, etc.
However, the worksheet to use depends on the value of two other cells (A1
and B1). For example, if the value of A1 is U, the value of B1 is 3, then
the formula would become =U3!C2
How can I cook up such a formula, preferably without the use of any vba?
I need a formula that references a cell (say C2) of one of the worksheets
called U3, U4, V3, V4, etc.
However, the worksheet to use depends on the value of two other cells (A1
and B1). For example, if the value of A1 is U, the value of B1 is 3, then
the formula would become =U3!C2
How can I cook up such a formula, preferably without the use of any vba?