Good morning all
Please Help
Can someone please advise me how to look up the address of a customer.
I basically want to type a customer name into Cell 1 and in lets say cell 3 i want a drop down showing the multiple address to chose based on the customers name.
I have already populate a sheet with customer details !
ATTACHED IS A SAMPLE SHEET OF CUSTOMERS AND SHEET 2 IS MY DESIRED OUTCOME
thanks
TimTEST.xlsx
Bookmarks