|
|
#1
03-26-2024, 04:05 AM
|
||||
|
||||
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 |
Windows 11 
Office 2021
Threaded Mode