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?