Results 1 to 7 of 7

Searchable Excel phone directory problem

Threaded View

  1. #1
    Registered User
    Join Date
    04-21-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2007
    Posts
    13

    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
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1