Latitude/Longitude Porblem

Hi Guys

Bit of a strange problem but I hope somebody can help.

Basically I have Two sets of data I have attatched an example of my data. However i will do have a huge database to work through.

The data contains locations of two seperate databases some of the data will be the same on the first database as the second and some will be different.

I need to find the locations that are the same and then compare the data in the third collumn.

However as there is a differnet amount of locations in each database this is proving difficult because i cannot just sort the data to get it in the right order.

What i need to solve this problem is a function/Macro that will search through the data and find the lattitudes and longitudes that are the same(regardless of the cells they are in) and if they are the same then compare the data in the third collumn.

I hope someone can help as ive had this problem for a long time.

If you need any more info please ask.

Thanks in advance

Ed

Hi
Thanks for your reply that works well.

However I believe i may have asked the wrong question before.

What i really need to do is to compare the two database locations. If two locations are are the same i would like to copy the locations next to each other in to sheet 2 along with the data in the third collumn. This would enable me to easily edit the data in collumn 3 if it is different.

Sorry to be a pain. Thanks for your help so far. Thsi may be too big a task to ask you to do so any advice you could give i would appreciate.

Thanks again

Edd