Create if formula based on selection in drop down list

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?

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

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.