Refer to named cell - excel thinks its a string of text 1

[blackduck]

How can I get excel to recognise that I want to refer to a defined name and not just the actual words?

Example:
A1 B1 C1
Chill =A1&C1 Out

A200 is a cell named ChillOut and its contents are blabla. I want cell B1 to display blabla not the word chillout. I know it will work if I just typed =chillout in cell B1 but I want it calculated based on what is in another cell.

please help, its driving me nuts
thanks

 

[SkipVought]

Hi,
[tt]
A1 B1 C1
Chill =indirect(A1&C1) Out
[/tt]


Skip,
[sub]
[red][/red]
[/sub]

 

[blackduck]

Skip I just want to hug you!

Thanks so much - it works perfectly.
and thanks for such a quick reply. Read, replied and resolved in 7 min for something I couldnt think of for the last 24hrs!

luv ya
K

 

[SkipVought]

Nicest thing an Aussie has ever said to me.

Skip,
[sub]
[red][/red]
[/sub]

 

[MallardVHS]

Hey Cousin,

... its driving me nuts

Not at all surprised when Skip solves a problem. That would be like being stunned by a sunrise.


BTW - did you hear the pirate's response when asked about his ship's steering mechanism being stuck between his legs?

[gray]er, sea quote... [/gray]

ah, yes, DeDucktion


[blue]________________________________________________________
Some folks put their money where their mouth is. I just pay my bill. [/blue]