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

[hortguy510]

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.

 

[Max]

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

 

[hortguy510]

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]

Glad to pass it on, Chuck!
Thanks for calling back ..