Formula help

[jcaptchaos2]

Hello,

I have this formula,

=INDIRECT("'Shift 1'!B3")

what I would like to do is use is Cell "B1" in place of "Shift 1" in the formula, so if I type "Shift 2" in cell "B1" it would go to worksheet "Shift 2" and pull cell "B3".

 

[Jonmo1]

Try

=INDIRECT("'"&B1&"'!B3")

 

[MrKowz]

Try:

=INDIRECT("'"&B1&"'!B3")

 

[jcaptchaos2]

Wow that was fast , Thanks guys for the quick reply.

 

[T. Valko]

Hello,

I have this formula,

=INDIRECT("'Shift 1'!B3")

what I would like to do is use is Cell "B1" in place of "Shift 1" in the formula, so if I type "Shift 2" in cell "B1" it would go to worksheet "Shift 2" and pull cell "B3".

Try it like this...

=INDIRECT("'"&B1&"'!B3")

 

[MrKowz]

Wow that was fast , Thanks guys for the quick reply.

Not a problem. Thanks for the feedback.