Using cell value as a defined name

[ai18ma]

Good Day Dear Experts,

I wish to use the text value in a cell to refer to a defined Name with a specific numerical value.
Somehting like this:
A1 = bwt
Using Name Definition: bwt = 100.
C1 = bwt* (another number).
However, I want to use the cell value as a reference to the defined Name, i.e:
C1 = A1 * (another number)
Is that possible? If yes, how?

Thanks for your help.

 

[onlyadrafter]

Hello,

I think you may need in C1 = INDIRECT(A1) * (another number)

 

[ai18ma]

Hi,

thanks for the answer.
INDIRECT seems to work only if the name refers to a range, i.e. bwt = A1.
However, I have defined "bwt" as a constant without referring to a range, i.e. bwt = 100.
Here, INDIRECT didn't help. Or I couldn't get it to work.