To summarized the datas from the details workings by given the single input

I have an excel file having the month wise model cost breakup e.g.Prod.Qty,CKD,Local etc.My problem is that I want to make a summary in a separate sheet showing the Input i.e. Model Code.If I give that input then automatic summary should be prepare.

For more clarification,please refer my attach file

I this file,having 2 sheets.One is details and other is Summary sheet.

Plaese focus the cell no.C4 in the summary sheet.When,I give the model code then the summary should be ready from the details sheet datas range,month wise.

Hi Pradeep..
In some of your Model Code.. are not in same order.. so you have to go for double lookup.

Try this assuming.. atleast Prod.Qty,CKD,Local,E.Oil,Paint Cost,Steel,TOTAL MATERIAL COST are in order in all case..

In Sheet Summary C6 , use below formula...

Formula:

Please Login or Register  to view this content.

Thank you sir for excellent solution provide to me.