Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 07-07-2017, 12:31 AM
Kubi Kubi is offline Expand on carton count Windows XP Expand on carton count Office XP
Advanced Beginner
Expand on carton count
 
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
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to expand the gridlines Shahir Arifin Word 2 11-25-2016 10:40 AM
Expand on carton count Getting the Count formula to count all rows Jennifer Murphy Word Tables 11 08-23-2016 09:37 PM
How not disable expand/collapse LVP Word 3 12-21-2014 12:12 PM
Expand on carton count Expand a Word table SMT Word VBA 2 04-11-2011 04:40 AM
Grouping - expand all ejohns Excel 0 07-17-2009 07:15 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:37 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft