Yes, but I may need to explain my problem a little more. I want to be able
to dump a list of zip codes into the file and it spits out the lat and long
for those zip codes . My list could sometimes contain several hundred zip
codes. I know I can do this manually but I was hoping there was an easy way
to automate this process.

--
Mike


"Biff" wrote:

Hi!

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.

Don't you already have that on Sheet1?

Biff

"Otillio" wrote in message
...
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