View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Otillio
 
Posts: n/a
Default 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