Background: I work for a Recruiting Group & we have a list of candidates in Excel with all mailing info, including the County they live in. I need to add a column called "Recruiting Region" which can look at the County cell and return the "Recruiting Area".
So for example, in TX, we have a "DFW" Recruiting Region which includes the Counties of Dallas, Tarrant, Denton, etc.
I need it to look at the row for John Smith who lives in Denton County and have it enter "DFW" in the Recruiting Region. How would I set this up?
Thank you for your help in advance. Please let me know if this is unclear.