View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
hortguy510 hortguy510 is offline
external usenet poster
 
Posts: 2
Default 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.