Lookup formula help to extract multiple values based on one reference

[Samrat77]

Hi All,
I am looking for a help to get the below problem solved


Sheet "Production Consumption" have batch wise consumption of Raw Materials for multiple products

Sheet "Costing", I am planning to use Batch Number as reference and once I select any batch number, all the data in table below batch number cell should get auto populated.

I am flexible to use any kind of formula to get this.

Thanks for support in advance.

Lookup_Samrat.xlsx

Thanks
Samrat

[etaf]

sorry i'm not following the spreadsheet or explanation

where is this

Sheet "Costing", I am planning to use Batch Number as reference and once I select any batch number, all the data in table below batch number cell should get auto populated.

can you provide some actual results expected and explain why , manually

[davsth]

I agree it is unclear but if you have O365 is all you are wanting a filter formula?

in d14 =FILTER('Production Consumption'!F4:F26,'Production Consumption'!A4:A26=J3)

and then similar for the other columns

[Samrat77]

Thanks for your quick Reply and please find the attached file Lookup_Samrat_V1, wherein

Sheet "Production Consumption" is actual data output from my system and I am trying to build a batch costing template(sheet named "Costing") and this time I have populated this template manually to give a look what I am seeking.

Hope it gives clear inputs now..

Lookup_Samrat_V1.xlsx

Thanks
Samrat

[Glenn Kennedy]

try:

=FILTER('Production Consumption'!B4:K26,'Production Consumption'!A4:A26=Costing!B2)

and format column A as date

[AliGW]

Clrea A5 to J15 on the Costing sheet, then this in A5:

=FILTER('Production Consumption'!B4:K26,'Production Consumption'!A4:A26=Costing!B2)

[Samrat77]

Thanks, it worked. Appreciate your help....

[Samrat77]

Thanks a lot, it worked for me and appreciate your help

[AliGW]

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.