View Single Post
  #1   Report Post  
Old January 9th 13, 05:41 AM
ricklongbow ricklongbow is offline
Junior Member
 
First recorded activity by ExcelBanter: Jan 2013
Posts: 5
Talking How to use matching values in two worksheets to return another value

Hello all. My first post. I have two worksheets A and B. Both contain columns of five digit zip code values. A is of names and address (street/city/state/zip different columns) with 3500 rows. B is a sheet with every zip, city, state and county in the US. B is sorted by zip.

For each contact in A I want to lookup the same zip in B and copy(merge?) the appropriate (same row) county into A.

"A" example
Barnaby Joyce 2 Joyce Plaza Stony Point NY 10980
Frank Polloni 614 C Way W Stockbridge MA 01266
John Wall 2 Strawtown Road West Nyack NY 10994

"B" example
10980 STONY POINT NY ROCKLAND
00544 W STOCKBRIDGE MA BERKSHIRE
10994 WEST NYACK NY ROCKLAND

Do the sheets need to be sorted ascending by zip to do the lookup?

Thank you