Auto Populate cells when selected from multiple drop down list Hi Kindly help me

Question

Auto Populate cells when selected from multiple drop down list

Hi

Kindly help me to resolve the issue of auto populate when data are selected from multiple drop down list. Attached copy of work book link mentioned below

When I select Product from drop down, automatically MBP & Conversion extra displayed. I am unable to find a solution how to auto fill Dimension Extra, Grade Extra, Spl grade extra, Packing Extra, freight (1) & (2) & Excise and arrive actual selling price ( these details are linked with width)) . Expecting an early solution please!

Thanks and Regardss!!

Explanation / Answer

Hi..

Enter the below formula as Array Formula in B7 i.e. not by pressing ENTER after entering your formula but by pressing CTRL+SHIFT+ENTER. This will put { } brackets around the formula which you can see in Formula Bar. If you edit again, you will have to do CTRL+SHIFT+ENTER again. Don't put { } manually...

Drag down the formula for other rows...

=INDEX(OFFSET($A$20,0,ROWS($1:4),,78,,1),MATCH($B$3&$B$4&$B$5&$B$6,$A$20:$A$97&$B$20:$B$97&$C$20:$C$97&$D$20:$D$97,0)))

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.