Forum Discussion
kimme0461
Aug 15, 2023Copper Contributor
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 i...
JKPieterse
Aug 16, 2023Silver Contributor
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
- kimme0461Apr 26, 2024Copper Contributor
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
- JKPieterseApr 29, 2024Silver Contributor
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.