Forum Discussion
IF formula & Lookup Formula Help to create semi automatic packing slip
Hi I am trying to create a packing slip tab in my excel workbook which when I enter the unique order number will then populate the packing slip lines. I have managed to so this for the customer ...
An alternative which works with formulas available in Excel 2013 is in the attached file. The formulas for ID and Quantity are arrayformulas and have to be entered with ctrl+shift+enter if one doesn't work with Office 365 or Excel 2021 or Excel for the web.