I have a spreadsheet with a column listing Lengths and another listing Widths. I need help building a formula that will look at the lengths and depths, then auto-generate which machine code the item goes to. If you look at my attached spreadsheet I have a little table in the top right listing-out the minimum lengths and widths for each machine. I would like the formula to choose the machine with the smallest sizes. For an example, in row 4 in L4 I would like it to generate code 701, even though it could also work for machine code 142. Any help would be much appreciated. Thank you.
Bookmarks