Thread: Use look-up table in Excel and enter into a "county" column, same
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default 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
---
Reply With QuoteReply With Quote