Simple Indirect Function?

S

Steve

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!
 
P

PCLIVE

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

--
 
P

PCLIVE

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

Thanks.
Paul

--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top