Show a named range within a label (not VBA)

[rick]

I have a sheet that has a column value which states "Expenses in working
currency".
I would like to have it say "Expenses in USD" or "Expenses in MXP"
(whatever the currency is).
I have a named range in another sheet, ProjectInformation, that holds the
working currency value.
Not in VBA, but in the sheet I need to say something like: ="Expenses in" &
(ProjectInformation!C9) but this gives me an error.

Help, please.

Thanks.

Rick

 

[Rick Rothstein]

If I understand your set up correctly, try it this way...

="Expenses in "&ProjectInformation