Searchable Excel phone directory problem

Hi,
I am trying to return information from a table based on entering a person's surname and then have that person's phone number and extension, mobile number and role/title returned using vlookup.

I have been successful in that it works until I enter a surname which has more than one instance. It will only return the first instance.

Is there a way that if a surname is entered and there is more than one occurence, then all the first names appear as a dropdown under the First name cell and once a first name is selected, the rest of the data is pulled across for the selected person?

I have attached the spreadsheet for reference. The first sheet entitled "Search" lets you enter the surname and first name and all the relevant data is pulled from Sheet 2 entitled "All_Offices"

Kindest regards

That's brilliant. Worked like a charm. Thank you very much

Nice Job On the phonebook

Hey

I have a contact list with the headings "Contact Person", "Company", "Phone Number", "Cellphone Number", "Email", etc. I want to be able to search for the contact and have is search from either "Contact person" column or the "company" column. Please help