Hello, thanks to member assistance I have almost completed my task. I appreciate your time and guidance.
I am at the last piece of the puzzle but am stuck.
I have a workbook with 2 worksheets, Main and Data.
On the main sheet I would like to enter my customer's account number in column A. From that, I would like vlookup to populate the customer's company name in column B, have Data Validation return a drop down box with contact names related only to that account number which I can pick from in column C, and then have vlookup populate column D and E with the email and phone number of the contact I selected from the drop down.
The vlookup parts I can do, but I can't get the drop down box to populate. I would like to keep the "Data" worksheet information organized the way it currently is.
I have attached a sample sheet with the problem. Can someone please help to fix the error of the drop down box, and get it to populate with the correct contact names associated to the company/acct#?
ContactSamp.xlsx
Thank you!
Bookmarks