I am trying to look up a particular part number, compare to find the closest quantity and return the cost associated with that closest quantity.
Spreadsheet A
Part Number QTY Cost
123 18 $14.00
123 72 $9.21
123 144 $7.83
Spreadsheet B
Part Number QTY Cost
123 25 Would return $14.00
123 59 Would return $9.21
Spreadsheet A
Part Number QTY Cost
123 18 $14.00
123 72 $9.21
123 144 $7.83
Spreadsheet B
Part Number QTY Cost
123 25 Would return $14.00
123 59 Would return $9.21