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

Report
-
 HappyAdminy -
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.

1 reply

Posts
1852
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 7, 2020
136
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
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Thank you so much!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!