Excel Naming usage automation

[daniel22bg]

Hello,

I need help with the following stuff:

I have named some sells in my worksheet, eg. A1 is named Coupon, A2 is named maturity etc.

Now I need an excel or VBA based function that looks at the value of a given cells and then connects that value with the content of a corresponding named cell.

For example, let's say that A1 is named Coupon, and countains 5.5%.

Then I have the content of B2 is 'Coupon'
function (B2) = 5.5% (which is the content of A1).

Any help will be appreciated.

 

[VoG]

If I understand correctly

=Coupon

 

[GlennUK]

Maybe:

=INDIRECT(B2)

?

 

[daniel22bg]

No, indirect does not work here. =Coupon works, but it does not achieve the level of automatization that I need. I need a function like indirect(Coupon) that works

 

[GlennUK]

If A1 is a named cell, named as Coupon, and B2 has contents of Coupon, I don't see how the INDIRECT could fail. In what way does it not work here?

 

[daniel22bg]

Hey, actually indirect(.) worked! Thanks a lot!