Lookup different multiple criteria and multiple results

ykouas

New Member
Joined
Sep 16, 2019
Messages
2
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
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Watch MrExcel Video

Forum statistics

Threads
1,095,350
Messages
5,443,954
Members
405,258
Latest member
daveyf

This Week's Hot Topics

Top