+ Reply to Thread
Results 1 to 5 of 5

Auto-populate fields based on selection from dropdown?

  1. 03-20-2009, 03:07 PM #1
    Aswert
    Aswert is offline
    Registered User
    Join Date
    03-20-2009
    Location
    New York, NY
    MS-Off Ver
    Excel 2007
    Posts
    3

    Auto-populate fields based on selection from dropdown?

    Hi there,

    I'm interested in getting the cells in a column to auto-fill based on the answers that I select from a dropdown. I know this is probably some version of a lookup formula, but I can't figure out how to have the fields populate based on the selection in the dropdown. I'm guessing I have to name the values in each column as a range. I've attached an example sheet that explains when I need.

    Does anyone know how to do this?

    Thanks!

    C
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-20-2009, 03:11 PM #2
    mewingkitty
    mewingkitty is offline
    Forum Contributor mewingkitty's Avatar
    Join Date
    09-29-2008
    Location
    Fort McMurray, Alberta, Canada
    MS-Off Ver
    Excel 2003
    Posts
    949

    Re: Auto-populate fields based on selection from dropdown? 

    Please Login or Register  to view this content.
    That should get you going!
    =IF(AND(OR(BLONDE,BRUNETTE,REDHEAD),OR(MY PLACE,HER PLACE),ME),BOW-CHICKA-BOW-WOW,ANOTHER NIGHT ON THE INTERNET)
    Reply With QuoteRegister To Reply
  3. 03-20-2009, 03:16 PM #3
    Aswert
    Aswert is offline
    Registered User
    Join Date
    03-20-2009
    Location
    New York, NY
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Auto-populate fields based on selection from dropdown?

    Does that formula work for you when you put it into the example spreadsheet? I finished it off with 'FALSE' for exact match, but I'm not pulling the cell values.
    Reply With QuoteRegister To Reply
  4. 03-20-2009, 03:20 PM #4
    mewingkitty
    mewingkitty is offline
    Forum Contributor mewingkitty's Avatar
    Join Date
    09-29-2008
    Location
    Fort McMurray, Alberta, Canada
    MS-Off Ver
    Excel 2003
    Posts
    949

    Re: Auto-populate fields based on selection from dropdown?

    Yessiroony
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 03-20-2009, 03:26 PM #5
    Aswert
    Aswert is offline
    Registered User
    Join Date
    03-20-2009
    Location
    New York, NY
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Auto-populate fields based on selection from dropdown?

    Wowzeroo! Thanks a lot
    Reply With QuoteRegister To Reply
+ Reply to 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