Dynamic worksheet references

I want to do something like this...

1st worksheet name "targetTab"
2nd worksheet name "sourceTabA"
3rd worksheet name "sourceTabB"



In cell A1 of the sourceTabA worksheet is "APPLES"
In cell A1 of the sourceTabB worksheet is "BANANAS"

I want a formula to put in cell A1 of the targetTab worksheet so that
when I enter "sourceTabA" in cell A2 of the worksheet the formula
returns "APPLES" then when I enter "sourceTabB" in cell A2 the formula
returns "BANANAS".

Can someone help me with this please?


Thanks!

=INDIRECT(A2&"!A1")

HTH
--
AP

"David Boothe" <not@onyourlife.net> a écrit dans le message de news:
MPG.1ee33a1f877004cf9896aa@newsgroups.comcast.net...
>I want to do something like this...
>
> 1st worksheet name "targetTab"
> 2nd worksheet name "sourceTabA"
> 3rd worksheet name "sourceTabB"
>
>
>
> In cell A1 of the sourceTabA worksheet is "APPLES"
> In cell A1 of the sourceTabB worksheet is "BANANAS"
>
> I want a formula to put in cell A1 of the targetTab worksheet so that
> when I enter "sourceTabA" in cell A2 of the worksheet the formula
> returns "APPLES" then when I enter "sourceTabB" in cell A2 the formula
> returns "BANANAS".
>
> Can someone help me with this please?
>
>
> Thanks!

=INDIRECT(A2&"!A1")

Sometimes references to worksheets require that the worksheet name be surrounded
by apostrophes:

=INDIRECT("'" & A2 &"'!A1")

If they're not needed, they won't hurt.

David Boothe wrote:
>
> I want to do something like this...
>
> 1st worksheet name "targetTab"
> 2nd worksheet name "sourceTabA"
> 3rd worksheet name "sourceTabB"
>
> In cell A1 of the sourceTabA worksheet is "APPLES"
> In cell A1 of the sourceTabB worksheet is "BANANAS"
>
> I want a formula to put in cell A1 of the targetTab worksheet so that
> when I enter "sourceTabA" in cell A2 of the worksheet the formula
> returns "APPLES" then when I enter "sourceTabB" in cell A2 the formula
> returns "BANANAS".
>
> Can someone help me with this please?
>
> Thanks!

--

Dave Peterson