Closed Thread
Results 1 to 6 of 6

cant pull data from another sheet after drop down list selection from another sheet

  1. 07-31-2009, 07:35 AM #1
    bengalvfan
    bengalvfan is offline
    Registered User
    Join Date
    07-31-2009
    Location
    Ramstein AB, Germany
    MS-Off Ver
    Excel 2007
    Posts
    2

    cant pull data from another sheet after drop down list selection from another sheet

    I have an excel workbook with two sheets.

    Sheet 1 has a list of people names, rank, address, and phone numbers
    Sheet 2 has boxes where a user can select a last name from all last names in sheet1

    What I want to happen after the user selects the last name in sheet 2 is for it to automatically fill in the rest of the data (ie Rank, First Name, Address, city, Home phone number, Cell Phone number)

    What do I need to do in order for this to work?
    Attached is a very small example of my much larger project. Thanks!

    Dan
    Attached Files Attached Files
    Last edited by bengalvfan; 07-31-2009 at 11:07 AM.
    Reply With QuoteRegister To Reply
  2. 07-31-2009, 07:54 AM #2
    Palmetto
    Palmetto is offline
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: cant pull data from another sheet after drop down list selection from another she

    See attached.

    Named Range created for the database and Last Name

    This formula, adjusted as needed to return the correct value
    =INDEX(Database,MATCH($D$11,LName,0),2)
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 07-31-2009, 11:07 AM #3
    bengalvfan
    bengalvfan is offline
    Registered User
    Join Date
    07-31-2009
    Location
    Ramstein AB, Germany
    MS-Off Ver
    Excel 2007
    Posts
    2

    Thumbs up Re: cant pull data from another sheet after drop down list selection from another she

    Thank you very much for your help. It works great.

    Dan
    Reply With QuoteRegister To Reply
  4. 07-31-2009, 02:27 PM #4
    Palmetto
    Palmetto is offline
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: cant pull data from another sheet after drop down list selection from another she

    No problem ... the US Marine Corps is glad to help a fellow service member (well . . . former US Marine, anyway - not quite as lean, not nearly so mean, but still a Marine -- )
    Reply With QuoteRegister To Reply
  5. 03-12-2012, 09:33 PM #5
    uncle marc12
    Guest

    Re: cant pull data from another sheet after drop down list selection from another she

    Great forum. I have a similar problem and feel this is my answer however I'm unclear what "Database" refers to in the formula and how one sets up this "Database".

    I guess I'm wondering how do you define and establish this "Database".

    Link to my original question.






    Quote Originally Posted by Palmetto View Post
    See attached.

    Named Range created for the database and Last Name

    This formula, adjusted as needed to return the correct value
    =INDEX(Database,MATCH($D$11,LName,0),2)
    Reply With QuoteRegister To Reply
  6. 07-22-2014, 06:29 AM #6
    sumanraj321
    sumanraj321 is offline
    Registered User
    Join Date
    07-17-2014
    Location
    chennai
    MS-Off Ver
    2013
    Posts
    1

    Re: cant pull data from another sheet after drop down list selection from another sheet

    excel drop down list sheet names??????
    Reply With QuoteRegister To Reply
Closed Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1