Use look-up table in Excel and enter into a "county" column, same
 

I would like to enter names and mailing addresses with column headings such
as fname,lname, address, city, state, zip and have Excel look up the county
where the zip code is located and enter the county name into the same row in
a "county" column. This has to be easier than I am making it. I assume I
have to provide an array with columns such as "zip" and "county" for Excel to
search.

Use look-up table in Excel and enter into a "county" column, same
 

"hortguy510" wrote:
I would like to enter names and mailing addresses with column headings such
as fname,lname, address, city, state, zip and have Excel look up the county
where the zip code is located and enter the county name into the same row in
a "county" column. This has to be easier than I am making it. I assume I
have to provide an array with columns such as "zip" and "county" for Excel to
search.

Try Debra's nice coverage on VLOOKUP or INDEX/MATCH at her:

http://www.contextures.com/xlFunctions02.html
VLOOKUP

http://www.contextures.com/xlFunctions03.html
INDEX/MATCH

There's also some sample workbooks available for d/l & study
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Use look-up table in Excel and enter into a "county" column, s
 

Thanks for the tip, Max. Deb's Contextures.com was just what this newbie
needed. I learned a lot. I recommend it to anyone for the basics.
Chuck, R.D.O.H.
(recently designated office hero)

"Max" wrote:

"hortguy510" wrote:
I would like to enter names and mailing addresses with column headings such
as fname,lname, address, city, state, zip and have Excel look up the county
where the zip code is located and enter the county name into the same row in
a "county" column. This has to be easier than I am making it. I assume I
have to provide an array with columns such as "zip" and "county" for Excel to
search.

Try Debra's nice coverage on VLOOKUP or INDEX/MATCH at her:

http://www.contextures.com/xlFunctions02.html
VLOOKUP

http://www.contextures.com/xlFunctions03.html
INDEX/MATCH

There's also some sample workbooks available for d/l & study
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Use look-up table in Excel and enter into a "county" column, s
 

Glad to pass it on, Chuck!
Thanks for calling back ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"hortguy510" wrote:
Thanks for the tip, Max. Deb's Contextures.com was just what this newbie
needed. I learned a lot. I recommend it to anyone for the basics.
Chuck, R.D.O.H.
(recently designated office hero)