Value Pulled Per List Drop Down selection

[NKRA]

Hello All,

I have attached my problem workbook in explanation, I need help of pulling values from particular data by referencing selection in drop down list via some formula. I thought about using the SUMPRODUCT and VLOOKUP but couldnt reference the values in drop down list.

Hope my example helps the full explanation.

Thanks in advance for your help and support.

NK

[Ron Coderre]

Your posted workbook doesn't seem to define Types 1,2, or 3.
Absent that information...try this

Please Login or Register  to view this content.

Copy that formula down and across through X5.

Is that something you can work with?

[NKRA]

Magic formula worked, but with further review and my need. I have additional step to be performed.

I have updated the excel workbook with details behind the same. I would need suggestion as well as formula for step 2.

Thanks in advance for the help

Hope this solves my problem.

NK

[NKRA]

Here is the way I have figured out to do the step 2.

Can someone validate if this is right way to do

=(IF(($C$13="Regular"),(((SUM(J3:X3))-(J3+K3))),(IF(($C$13="Polished"),(((SUM(J3:X3))-(K3+L3))),(IF($C$13="Grained",(((SUM(J3:X3))-(J3+L3))),0))))))

[NKRA]

Can someone please validate? If I have the right way captured of doing the Step 2?

Regards
NK