i need help to lookup multibale values from different tables

[wally_mus]

hello,

i have been trying for three days now to resolve and issue i have come across on Excel,

i am trying to build a stock management system that would show me how much stock i have. i have a sheet with many tables with the same structure, each table represents the sales of each day. one the other sheet i am trying to use the vlookup on the barcode to calculate how many items have been sold throughout the days of business.

many thanks

tasneem.xlsx

[BadlySpelledBuoy]

Hi and welcome.

I think it would be easier to help of you could attach a sample workbook showing your expected outcome. Manually generate it and if not completely obvious, tell us how you arrived at the final figures.

Could I just ask, is the data layout out of choice? It may seem convenient to have it laid out into neat daily tables, but in the long run it'll make things more difficult to draw information from. A long list is often the simplest approach and if you do want the daily tables they can be generated from the long list.

BSB

[wally_mus]

thank you for your response,

i have attached this picture of how i expect the final result to be, as the sold column should calculate the amount of sales of the product identified by the item code, however because everyday holds new sales in different tables i couldnt figure a way to use hlookup.

and normally i get the data from my paypoint machine the provides the data and layout which i only need to pate. the only issue i have at the moment is how to make the stock sheet calculate the sales. plus im not sure how to attach my file to the post so you could check it. </3

[AliGW]

Thank you for attaching a workbook. Hopefully, you will now get some help with your issue.

[AliGW]

I have just looked at your workbook and I cannot work out exactly what you are trying to do. You need to be more specific about what you expect to be coming from where and why.

This post will hopefully serve to bump your thread - you need to give more detail.

[wally_mus]

thank you very much for your support, i really hope if there if what i am need to do on excel is possible.

i have added more info and description on my sheet please check it for further explanation on what im trying to do.

many thanks

tasneem.xlsx

[Bosco]

The "Total sales" on sheet2 for each product

In "Sheet1" D4, copied down :

=SUMPRODUCT((Sheet2!$B$7:$B$500="Description")*(Sheet2!$C$7:$I$500=B4),Sheet2!$C$13:$I$506)

Regards
Bosco

[wally_mus]

thank you very much!!

big salute to the heroes who do not wear capes <3 *thumbs up*

[wally_mus]

im afraid it didnt quite work, i ended up with this. </3

tasneem.xlsx

[BadlySpelledBuoy]

I can see little wrong with Bosco's provided solution and it's difficult to spot why it's not working for you when we have nothing to double check against.

How about you fill in your expected results manually and we can go from there?

BSB

[Bosco]

Yes, the formula can be shortened to >>

=SUMPRODUCT(0+(Sheet2!$C$7:$I$500=B4),Sheet2!$C$13:$I$506)

but still don't know the OP's expected result.

Regards
Bosco