Hey guys, first post here.
I need a little help.
Basically I have two sheets, Sheet 1 contains the dimensions of parts I have at my warehouse, and the Box Types sheet contains the dimensions of boxes we have available. I think you can see where I am going with this. I'm trying to reference Box Types in sheet 1 to find the most suitable box to ship the part in.
I started with an IF AND formula
Which just checks each dimension and if they are all true, it returns the box size, if not, it moves on to the next line scaling all of the referenced cells by 1.
Now, I want to do this for all lines, but cannot figure out how to do loops or counters in Excel.
=IF(AND(D2<='Box Types'!D2, E2<='Box Types'!E2, F2<='Box Types'!F2),'Box Types'!C2,"N/A")
Here is the Item Dimensions sheet with the "Box" column using the formula. It only works line by line in both sheets right now. The N/A is just a placeholder for now, but I would like to add a "None Available" output if there are non found on the Box Types list after going through all values.
Here is the Box Dimensions sheet being referenced.
Does anyone have any advice on how to go about doing this? Thanks!
I need a little help.
Basically I have two sheets, Sheet 1 contains the dimensions of parts I have at my warehouse, and the Box Types sheet contains the dimensions of boxes we have available. I think you can see where I am going with this. I'm trying to reference Box Types in sheet 1 to find the most suitable box to ship the part in.
I started with an IF AND formula
Which just checks each dimension and if they are all true, it returns the box size, if not, it moves on to the next line scaling all of the referenced cells by 1.
Now, I want to do this for all lines, but cannot figure out how to do loops or counters in Excel.
=IF(AND(D2<='Box Types'!D2, E2<='Box Types'!E2, F2<='Box Types'!F2),'Box Types'!C2,"N/A")
Here is the Item Dimensions sheet with the "Box" column using the formula. It only works line by line in both sheets right now. The N/A is just a placeholder for now, but I would like to add a "None Available" output if there are non found on the Box Types list after going through all values.
Here is the Box Dimensions sheet being referenced.
Does anyone have any advice on how to go about doing this? Thanks!
