#1
|
||||
|
||||
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. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge with Excel Named Range | Rocki | Mail Merge | 1 | 01-10-2020 02:06 PM |
How to reference a named range in a different file within a formula | Brock297 | Excel | 1 | 10-25-2018 08:50 AM |
Define a spreadsheet range using two named variables | persist | Excel | 2 | 05-13-2014 10:56 PM |
Excel - move with tab through named range | mjlaw | Excel | 4 | 03-26-2012 10:40 AM |
Named range drop-down | jgelpi16 | Excel | 1 | 04-08-2011 03:08 PM |