Formula Help

[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?

[JMB]

=INDIRECT(A1&B1&"!C2")

"robot" wrote:

> 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?
>
>
>
>

[Rowan]

Try =INDIRECT(A1&B1&"!C2")

Hope this helps
Rowan

robot wrote:
> 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?
>
>
>