| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using the outcome of cell A in a formula in cell B as a worksheet
Cell A displays text based on an IF statement. for example: "Water"
I then have a worksheet titled "Water" and would like cell B to use the text displayed in Cell A ("Water") to look at a cell reference on the "Water" worksheet. So the worksheet reference in cell B's formula is dynamically changing based on the text in cell A. Is this possible. Thanks in advance for any help on this. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using the outcome of cell A in a formula in cell B as a worksheet
Look in HELP for the INDIRECT() function
-- Kind regards, Niek Otten Microsoft MVP - Excel "Upgrade" wrote in message ... | Cell A displays text based on an IF statement. for example: "Water" | | I then have a worksheet titled "Water" and would like cell B to use the text | displayed in Cell A ("Water") to look at a cell reference on the "Water" | worksheet. | | So the worksheet reference in cell B's formula is dynamically changing based | on the text in cell A. | | Is this possible. | | Thanks in advance for any help on this. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using the outcome of cell A in a formula in cell B as a worksheet
=INDIRECT(A1&"!B9")
to get cell B9 from the sheet displayed in A1 -- Gary''s Student - gsnu200758 "Upgrade" wrote: Cell A displays text based on an IF statement. for example: "Water" I then have a worksheet titled "Water" and would like cell B to use the text displayed in Cell A ("Water") to look at a cell reference on the "Water" worksheet. So the worksheet reference in cell B's formula is dynamically changing based on the text in cell A. Is this possible. Thanks in advance for any help on this. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| varying a cell and seeing the outcome | Excel Worksheet Functions | |||
| how do i get a cell to fill red/blue as the outcome of a formula? | Excel Worksheet Functions | |||
| Locking cell depending on outcome of formulae | Excel Discussion (Misc queries) | |||
| Changing the font of a cell dependant on the outcome | Excel Worksheet Functions | |||
| wrong calculation in excel? formula outcome < cell value?? | Excel Worksheet Functions | |||
Hybrid Mode
