+ Reply to Thread
Results 1 to 5 of 5

When drop down is selected I want text from another list to populate different cell

  1. #1
    Registered User
    Join Date
    07-26-2013
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2007
    Posts
    6

    When drop down is selected I want text from another list to populate different cell

    Hello everyone,

    I have a name drop down list in A1 with the drop down information in H1:H15. I have a corresponding phone number list in I1:I15.
    If A1=H1, then B1=I1, or A1=H2, then B1=I2....etc.

    I have tried =IF(A1=H1,I1," ") and get the result but I do not know how to add H2 through H15 or the corresponding I2 through I15 so that when another name is selected, it's corresponding number populates B1.

    Thank you for your help because I'm sure this would be considered "elementary" by most.

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,577

    Re: When drop down is selected I want text from another list to populate different cell

    Pl attach a dummy file.

  3. #3
    Registered User
    Join Date
    07-26-2013
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: When drop down is selected I want text from another list to populate different cell

    Attachment 253106

    Here's a dummy file.

    Thank you

  4. #4
    Registered User
    Join Date
    07-26-2013
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: When drop down is selected I want text from another list to populate different cell

    Attachment 253369
    Okay, so I tried the following formula: =LOOKUP(A10,H:H,I:I) and it works but...I keep getting "n/a" in any cell that is blank. How do I make the cell remain blank if A1 is blank?

    Thanks

  5. #5
    Registered User
    Join Date
    07-26-2013
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: When drop down is selected I want text from another list to populate different cell

    Okay, so after I made a range I nested a VLOOKUP in an IFERROR : =IFERROR(VLOOKUP(A1,contacts,2,FALSE)," ") Thanks for "teaching me how to fish" by not offering any help....Great forumAttachment 253379

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Automatically Populate Data to new worksheet when a text is selected in a drop down.
    By ryemon7650 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-17-2013, 02:53 AM
  2. [SOLVED] Auto populate form text box when item selected from a drop down
    By Wales MB in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-14-2012, 05:53 AM
  3. how to create a drop down list that will populate multiple cells after selected
    By aaronriggle in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-07-2012, 06:59 PM
  4. Replies: 1
    Last Post: 07-16-2012, 10:42 PM
  5. auto populate cell when selected drop down item chosen
    By palmer19 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-13-2010, 07:16 AM

Tags for this Thread

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