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. -:)🙂
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.
You may try this...
In D2
=INDEX(OFFSET(INDEX(Sheet2!C:C,MATCH(B2,Sheet2!C:C,0)),,,10,3),MATCH(C2,OFFSET(INDEX(Sheet2!C:C,MATCH(B2,Sheet2!C:C,0)),,,10),0),2)In E2
=INDEX(OFFSET(INDEX(Sheet2!C:C,MATCH(B2,Sheet2!C:C,0)),,,10,3),MATCH(C2,OFFSET(INDEX(Sheet2!C:C,MATCH(B2,Sheet2!C:C,0)),,,10),0),3)