named range vs text

[bmeehan]

I am trying to set up a dynamic p&l sheet for futures, stocks and fx
For foreign futures the value of a 1pt move is based in their currenc
rather than dollars. I have named ranges for each currency - ie Eur
spot Eur price, Jpy = spot Yen price, etc. Then in the spreadsheet I a
pulling from bloomberg the base currency which returns as text the bas
currency. When the base currency is the Euro bloomberg returns Eur bu
since this is as text it does not convert to the named range Eur whic
is equal to the current spot price. Is there a way to link these tex
values back to the named ranges? thanks

 

[Debra Dalgleish]

If the returned text is in cell B2, use the following formula to return
the value in the named range: =INDIRECT(B2)

 

[ivano]

=INDIRECT(text)