| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to use indirect function? | Excel Discussion (Misc queries) | |||
| Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
| Indirect function | Excel Worksheet Functions | |||
| Help with Indirect function ? | Excel Worksheet Functions | |||
| INDIRECT Function | Excel Worksheet Functions | |||
![Steve[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
