Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |