Excel- if this, than return that?
Solved/Closed
Related:
- Excel- if this, than return that?
- Excel date format dd.mm.yyyy - Guide
- Flipkart return comments - Guide
- Excel free download - Download - Spreadsheets
- Number to words in excel - Guide
- Excel marksheet - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Oct 26, 2016 at 01:36 PM
Oct 26, 2016 at 01:36 PM
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
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
Oct 27, 2016 at 01:57 PM