Excel- if this, than return that? [Solved/Closed]

Happy Adminy - Oct 26, 2016 at 12:48 PM - Latest reply:  HappyAdminy
- Oct 27, 2016 at 01:57 PM
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.
See more 

2 replies

Mazzaropi 1831 Posts Monday August 16, 2010Registration dateContributorStatus May 21, 2018 Last seen - Oct 26, 2016 at 01:36 PM
+1
Helpful
Happy Adminy, Good afternoon.

You must have a table with:
• County
• Recruiting Region
Ps.: Enter each County individually.

Example:
.............K................L
1
2......Dallas...........DFW
3......Tarrant.........DFW
4......Denton.........DFW
5......COUNTY 4.....REGION A
6......COUNTY 5.....REGION X

Then... you can use a VLOOKUP Function to do this job.

Suppose your table is at K2:L100

F4 --> County for John Smith

G4 --> =VLOOKUP(F4, $K$2:$L$100, 2, FALSE)

Copy it down

Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Was this answer helpful?  
Thank you so much!