Another problem - INDIRECT?

[Andrew Mackenzie]

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.

 

[Pete_UK]

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

 

[Andrew Mackenzie]

Many thanks Pete.


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

 

[Pete_UK]

You're welcome, Andrew - thanks for feeding back.

Pete