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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
hortguy510 said:
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.
Click to expand...

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

---
 
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)
 
Back
Top