Hi. I have a formula that uses dynamic named range as references as follows.

=INDEX(Kin1_,Match($D6,Item,0))

Is it possible that in $k$2 I enter Kin2_. How do I make the formulae in column G of BoMTemplateBldg sheet to change the column number Kin1_ to Kin2_? The col changes according to what is entered in $k2.
Attached is the workbook I am working on.
Thank you.

Attached Files

MS Excel Workshop Engg.xlsm (53.4 KB, 3 views)

Maybe like in the attached

Attached Files

MS Excel Workshop Engg_2.xlsm (54.2 KB, 3 views)

I was going to offer the same solution as xor, although if you want to copy down it might work better with INDIRECT($K$2) instead of INDIRECT(K2)

Perfect. Thank you. I need to do some further reading on INDIRECT.

Yes, I locked the reference. Thank you.

You can use the INDIRECT function to change the reference to a dynamic named range in a formula in cell G. Simply enter the name of the named range you want in cell $K$2 (for example, Kin2_), then change the formula as follows:
:=INDEX(INDIRECT($K$2 & "_"), MATCH($D6, Item, 0))
The formula will now automatically use the named range specified in cell $K$2.

Thank you Tessa.