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.
|