Hello All,
Sheet 1: I need cell E6 to return the correct amount based on two values
1st value is A6 the Model#
2nd value is C12 the Qty.
If C12 is below 5 then the result is 0
If C12 = 6-7, then I need a lookup on Sheet 2 that searches Sheet 1’s A6 Model#, on Sheet 2: Column A list...