Forum Discussion
Drop down formula to update multiple sets of columns based on what is selected
Yes, I am sure that will make it easier to digest.
[Tab](Adding Gains) - Cell A15 is a drop down - The drop down is a list [Tab](Gains B1:P1)
[Tab](Adding Gains) - If Drop down Cell A15 has Gain 2 selected I would like [Tab](Gains) C2:C11 numbers to copy to [Tab](Adding Gains) B2:B11
Whenever the drop down is changed to a different "Gain 1, Gain 2, Gain 3, ect." I would like for that data to be present in that column.
In the attached file, the formula in B2 is shown in the snapshot below:
Similar to B2 and C2, the formula in D2, copied down and across the range is:
=SUM(INDEX(StatData,ROW()-1,
MATCH(D$1,StatLabels,0)),
$B2:$C2)
Upon pressing Ctrl+F3, you will see the 4 defined named ranges, as shown in the snapshot below:
Twifoo - That is incredibly helpful. I thank you very much as I learned something that I wasnt aware is possible. Really great of you to help me better understand this 🙂
You're very much welcome!