Use the Cell Value to refer to a Defined Name

[saeed]

Good Day Experts,

Is it possible to use the text in a cell to refer to a Defined Name?
Something like this:
A1 = bwt
B1 = 100
C1 = "bwt" * B1
Using Name Definition: "bwt" = 10
Is it possible to write:
C1 = (some formula) A1 * B1?
The formula would extract the value in A1 ("bwt") and look up its value in Names, and then carry out the math Operation.

Many Thanks in advance.

 

[AliGW]

Try using the INDIRECT function: https://www.contextures.com/xlFunctions05.html