Box Number | L | W | H | SKU | Length | Width | Height | Correct Box |
1 | 30.5 | 30.5 | 30.5 | 40 | 40 | 40 | 2 | |
2 | 40.6 | 40.6 | 40.6 | 50 | 3 | |||
3 | 50.8 | 50.8 | 50.8 | 150 | 15 | 15 | 4 | |
4 | 150 | 15 | 15 | 30 | 30 | 30 | 1 | |
5 | N/A | N/A | N/A | 85 | 15 | 33 | 5 | |
6 | 120 | 30 | 30 | 1 | ||||
7 | 85.3 | 15 | 33 | 1 | ||||
8 | N/A | N/A | N/A | 1 | ||||
9 | N/A | N/A | N/A | 1 | ||||
10 | N/A | N/A | N/A | 1 | ||||
11 | 30 | 30 | 200 | 1 | ||||
12 | 164 | 24 | 24 | 1 | ||||
13 | 43.2 | 43.2 | 60 | 1 | ||||
15 | 52.5 | 47.5 | 52.5 | 1 | ||||
16 | 60 | 60 | 30 | 1 | ||||
17 | 100 | 20 | 100 | 1 | ||||
18 | 38 | 88 | 38 | 1 | ||||
19 | 85 | 60 | 85 | 1 |
I'm Looking to create a formula that will match products to the correct box/ and if there's no correct box to say match, the formula I have used only seems to work up to box 4, unsure why this. any help would be most appreciated
=IFERROR(INDEX(A$2:A$19,MATCH(1,(B$2:B$19>=F2)*(C$2:C$19>=G2)*(D$2:D$19>=H2),0),0))