Forum Discussion
TEMPLATE FORMATING
I am trying to create a Packing List template for our shipping business. In the "Ship to:" cell I have created a list of our customers to pick from. I would like that cell to populate the address information for the customer in a typical "mailing address" format...Name on first line, two address lines and then City, State, Zip on the 4th line. How can I achieve this? Currently I have the address information included in the list table, but it doesn't come into the template in the proper format.
Thank you for any help you can provide!
- You would typically use the XLOOKUP function to fetch the address information belonging to a customer. Can you share what your customer details table looks like? Make sure you replace existing information with made-up information before posting a screen-shot
JKPieterse sorry for taking SO LONG to get back to you on this question!
This is how I have my list on a separate sheet in the workbook. I'd be glad to share the workbook with you if that is allowed.
Thank you
kimme0461 As long as the data in the file is completely anonymous it should be no problem. If the forum doesn't allow sharing an Excel file, just make sure it is uploaded to any filesharing service you use and create a sharing link there and paste it here.
