Results 1 to 3 of 3

Thread: Create if formula based on selection in drop down list

  1. #1

    Create if formula based on selection in drop down list



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am new to Excel. Very new. Took me two hours to create a drop down list and 6 days to create a 3 part formula. What I am trying to do is create an IF function based on my selection in my drop down list......My drop down list has a list of counties. When I select a certain county, I want the an if function that will tell me what group that county is. Does this make sense?

  2. #2
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    767
    Articles
    0
    Excel Version
    2010
    Hi, and welcome to the forum.
    I would suggest using either a VLOOKUP or INDEX function to find and pick up the correct group from the group list using the cell holding the drop down selection as the search parameter.


    Hope that helps

  3. #3
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    767
    Articles
    0
    Excel Version
    2010
    Heres a spreadsheet that lets you choose a county from the dropdown list in D2 and shows you which country in the UK that the county is in.
    Attached Files Attached Files

Posting Permissions

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