Forum Discussion
Auto fill from consecutive drop down boxes
You can simply use the following formula in G2 on Sheet1...
=IFERROR(INDEX(Sheet2!$H$3:$H$4,MATCH($F2,Fixingtags,0)),"")
If that takes care of your question, please don't forget to accept my post which resolved your question as an Answer and hit the Like button. -:)🙂
Not sure what do you want to pull from Sheet2 into the Sheet1 as you didn't mock up the desired output but try the below formula which will pull the value from column D on Sheet2 into the Sheet1.
=IFERROR(OFFSET(INDEX(Sheet2!$C:$C,MATCH($B2,Sheet2!$C:$C,0)),MATCH($C2,Sheet2!$C:$C,0)-2,1),"")
The 1 (bold number) in the above formula will pull the value from 1 column right to the column C i.e. column D on Sheet2 so if you want to pull the info from column E, change it to 2.
Thank you so much!!!!!! Definitely beyond my knowledge of formulas but that is doing exactly what I needed.
I've added it into the D and E columns (with 1 changed to 2 for E).
Can I ask for a simpler one for the Fixing tags columns?
Have reattached with the Fixing tags drop down and values in Sheet2.
Again thank you very much!!
You can simply use the following formula in G2 on Sheet1...
=IFERROR(INDEX(Sheet2!$H$3:$H$4,MATCH($F2,Fixingtags,0)),"")
If that takes care of your question, please don't forget to accept my post which resolved your question as an Answer and hit the Like button. -:)🙂
Subodh_Tiwari_sktneer I've found some of the measurements aren't pulling through correctly.
Once I get to the Metro/Residential ThermalHeart/Metro ThermalHEART suites and the two sliders are fine but the Open Out Door and Window frames are pulling through incorrect information or just 0. Does this have anything to do with the Residential having six options while the rest have five?
Have reattached as made a couple of minor changes.
