Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Another problem - INDIRECT?
Another problem is driving me crazy this morning.
I have a formula that contains a reference to a range named dciEUR. I want to be able to change the reference to dciUSD or dciCHF etc depending on whether a certain cell contains EUR, USD or CHF. Can anyone help me with this? Thanks again in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Another problem - INDIRECT?
Instead of your reference to dciEUR in your formula, you can replace
it with: INDIRECT("dci"&A1) where A1 is assumed to contain EUR, USD or CHF. Give details of the formula you are using at the moment if this does not solve your problem. Hope this helps. Pete On Dec 8, 11:56*am, "Andrew Mackenzie" wrote: Another problem is driving me crazy this morning. I have a formula that contains a reference to a range named dciEUR. *I want to be able to change the reference to dciUSD or dciCHF etc depending on whether a certain cell contains EUR, USD or CHF. Can anyone help me with this? Thanks again in advance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Another problem - INDIRECT?
Many thanks Pete.
"Pete_UK" wrote in message ... Instead of your reference to dciEUR in your formula, you can replace it with: INDIRECT("dci"&A1) where A1 is assumed to contain EUR, USD or CHF. Give details of the formula you are using at the moment if this does not solve your problem. Hope this helps. Pete On Dec 8, 11:56 am, "Andrew Mackenzie" wrote: Another problem is driving me crazy this morning. I have a formula that contains a reference to a range named dciEUR. I want to be able to change the reference to dciUSD or dciCHF etc depending on whether a certain cell contains EUR, USD or CHF. Can anyone help me with this? Thanks again in advance. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Another problem - INDIRECT?
You're welcome, Andrew - thanks for feeding back.
Pete On Dec 8, 2:18*pm, "Andrew Mackenzie" wrote: Many thanks Pete. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
problem with indirect | Excel Discussion (Misc queries) | |||
Indirect Formula Problem | Excel Worksheet Functions | |||
Indirect vlookup problem | Excel Discussion (Misc queries) | |||
Indirect problem | Excel Discussion (Misc queries) | |||
INDIRECT Problem | Excel Discussion (Misc queries) |