Comparing files and extracting info.
I have the following situation I could use some suggestions on. Worksheet 1
is setup as follows and has 42,000 rows (all zips in the U.S.):
Zip Latitude Longitude
70504 59.443323 -150.343434
70507 45.343234 -34.488383
75075 85.343434 -35.959595
Worksheet 2 is a list of Zips Codes:
Zip
70504
70507
I would like to be able to compare worksheet 2 to worksheet 1 and create a
third worksheet that includes the latitude and longitude for the zip codes in
worksheet 2.
And suggestions???
Thanks,
--
Mike
|