View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andrew Mackenzie Andrew Mackenzie is offline
external usenet poster
 
Posts: 50
Default 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.