Lookup different multiple criteria and multiple results

[ykouas]

Hi MrExcel,

Hope you can help with the below, I've attempted to google but I'm struggling to find results.

I'm trying to fill the total material used on the following two screenshots (there are about 40 total), the problem is if we require a SW 38x63 timber to be cut at for example 2m, the stock they could use could be 3m, 3.6m or 4.8m and would like each of these in the stock used table so the workshop can fill in total used as they're cut. Also each sheet vary in types used and how many.

https://imgur.com/VYfX8FS
https://imgur.com/VYfX8FS

https://imgur.com/mtebFEh
https://imgur.com/mtebFEh


Stock lookup table is below with sensitive info removed but believe all that is necessary is there;

https://imgur.com/qMJHv1o
https://imgur.com/qMJHv1o

Hope that makes sense, and hope you can help.

Wanted result: https://imgur.com/5mxjz0h
https://imgur.com/5mxjz0h

 

[ykouas]

bump, still can't solve this
...