View Single Post
 
Old 07-07-2017, 12:31 AM
Kubi Kubi is offline Windows XP Office XP
Advanced Beginner
 
Join Date: May 2017
Posts: 34
Kubi is on a distinguished road
Default

G2 and H2 use VLOOKUP to return the specific pack sizes of the product. the current formula being used is....

=INT(H2/I2)&" full box of "&I2&" and "&MOD(H2,I2)&" inner's "

I just want to add pallets to this, the pallet qty will be determined by the VLOOKUP as is the pack Qty.
Reply With Quote