Hi There! This seems to be an easy function to write but I am totally failing to figure it out on my own. I hope someone here can help me! Here is the problem:
I have lists of counties that are associated with each of 4 regions of the state. So, for example North (Wise, Parker, Hood, . . .), South (Duvall, Webb, La Salle, . . .) and so on. For each of the 4 regions, there are 30+ counties listed.
I would like to be able to write a single function to just output the region based on which county is listed in the cell.
So, if A1 says "Hood" then A2 will say "North".
Thanks (in advance) for your help!
Jane
Bookmarks