#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. |
#2
|
|||
|
|||
Maybe like in the attached
|
#3
|
||||
|
||||
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)
|
#4
|
||||
|
||||
Perfect. Thank you. I need to do some further reading on INDIRECT.
|
#5
|
||||
|
||||
Yes, I locked the reference. Thank you.
|
#6
|
|||
|
|||
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. |
#7
|
||||
|
||||
Thank you Tessa.
|
|
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 |