Simple Indirect Function?
 

Hi all. In sheet1, cell A1 I have a pick list that has all the sheet
names in the workbook. In cell D5, I need a formula that is a cell
reference to B75 of whatever worksheet is selected in cell A1. Any
ideas? Thanks!

Simple Indirect Function?
 

=INDIRECT("'"&A1&"'!B75")
--
David Biddulph

"Steve" wrote in message
...
Hi all. In sheet1, cell A1 I have a pick list that has all the sheet
names in the workbook. In cell D5, I need a formula that is a cell
reference to B75 of whatever worksheet is selected in cell A1. Any
ideas? Thanks!

Simple Indirect Function?
 

=INDIRECT(A1& "!B75")

HTH,
Paul


--

"Steve" wrote in message
...
Hi all. In sheet1, cell A1 I have a pick list that has all the sheet
names in the workbook. In cell D5, I need a formula that is a cell
reference to B75 of whatever worksheet is selected in cell A1. Any
ideas? Thanks!

Simple Indirect Function?
 

But you'll need to add the single quotes if the sheet name in A1 has spaces
in it.
--
David Biddulph

"PCLIVE" wrote in message
...
=INDIRECT(A1& "!B75")

HTH,
Paul


--

"Steve" wrote in message
...
Hi all. In sheet1, cell A1 I have a pick list that has all the sheet
names in the workbook. In cell D5, I need a formula that is a cell
reference to B75 of whatever worksheet is selected in cell A1. Any
ideas? Thanks!

Simple Indirect Function?
 

I just noticed that. But for some reason, my testing showed it to work
without it. Do you have any idea why that would be?

XL2002

--

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
But you'll need to add the single quotes if the sheet name in A1 has
spaces in it.
--
David Biddulph

"PCLIVE" wrote in message
...
=INDIRECT(A1& "!B75")

HTH,
Paul


--

"Steve" wrote in message
...
Hi all. In sheet1, cell A1 I have a pick list that has all the sheet
names in the workbook. In cell D5, I need a formula that is a cell
reference to B75 of whatever worksheet is selected in cell A1. Any
ideas? Thanks!

Simple Indirect Function?
 

Never mind. I didn't read your reply correctly. I missed the part about
the space. Sorry for my confusion.

Thanks.
Paul

--

"PCLIVE" wrote in message
...
I just noticed that. But for some reason, my testing showed it to work
without it. Do you have any idea why that would be?

XL2002

--

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
But you'll need to add the single quotes if the sheet name in A1 has
spaces in it.
--
David Biddulph

"PCLIVE" wrote in message
...
=INDIRECT(A1& "!B75")

HTH,
Paul


--

"Steve" wrote in message
...
Hi all. In sheet1, cell A1 I have a pick list that has all the sheet
names in the workbook. In cell D5, I need a formula that is a cell
reference to B75 of whatever worksheet is selected in cell A1. Any
ideas? Thanks!