I'm working on a manufacturing costing sheet where I input the number of bends in Cell I3 a certain part gets. If the weight in Cell S3 or size in F3 of that part is over 60 lbs or 120 inches, it is to return a "1" or "2" answer to identify which list of bends and time factors to use =IF(ISNUMBER(I3),(IF(OR(S3>60,F3>120),(PRICESLIST!$N$18),(PRICESLIST!$N$11)))) PRICESLIST!$N$18 refers to the 2 identifying the 2nd chart. Then I want it to take the number of bends (between 1 and 4) and, in a new cell, give me the seconds from the correct chart.
1
No. of bends/part Seconds Factor
1 80 1
2 120 1.5
3 160 2
4 200 2.5
2
Big parts -over 120 in. length or 60 lbs.
No. of bends/part Seconds Factor
1 200 2.5
2 300 3.75
3 400 5
4 500 6.25
I've been using VLOOKUP, but have been getting errors. Is there a different way I can do this?
Bookmarks