Show a named range within a label (not VBA)

  • Thread starter Thread starter rick
  • Start date Start date
R

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
 
If I understand your set up correctly, try it this way...

="Expenses in "&ProjectInformation
 
Back
Top