| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to use matching values in two worksheets to return another value | New Users to Excel | |||
| compare data from different worksheets and return matching results | Excel Discussion (Misc queries) | |||
| search worksheets in same book to return value matching criteria? | Excel Worksheet Functions | |||
| matching two worksheets and return to different value | Excel Worksheet Functions | |||
| Return all matching values | Excel Worksheet Functions | |||
Threaded Mode
