Create if formula based on selection in drop down list

Suzette83

New member
Joined
May 23, 2013
Messages
1
Reaction score
0
Points
0
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?
 

Hercules1946

New member
Joined
Mar 22, 2013
Messages
794
Reaction score
0
Points
0
Location
York, England
Excel Version(s)
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
 

Hercules1946

New member
Joined
Mar 22, 2013
Messages
794
Reaction score
0
Points
0
Location
York, England
Excel Version(s)
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.
 

Attachments

  • Counties.xlsx
    12.1 KB · Views: 599
Top