Thread: [Solved] Named Range as reference in a formula
View Single Post
 
Old 03-26-2024, 04:05 AM
Marcia's Avatar
Marcia Marcia is offline Windows 11 Office 2021
Expert
  
Join Date: May 2018
Location: Philippines
Posts: 527
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default Named Range as reference in a formula
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
File Type: xlsm MS Excel Workshop Engg.xlsm (53.4 KB, 3 views)
Reply With Quote