how to match and pick excel data

[zerodegree]

I have data in two separate Excel files.

Excel 1: column:> Location - Code - weight


Excel 2 : column:> Location - Code - weight


I want to dump data in a new Excel file for common Location in these Excel file but code and weight will be from Excel 2 only.


Please see this Sample data:
----------------

Excel 1:
-----------
Location ------Code-----Weight
Paris 12 40
Germany 15 25
Africa 17 15


Excel 2:
-------------
Location ------Code-----Weight
Paris 78 34
Spain 15 25
Madrid 24 54


As you see Paris is a common location in this two excel , so I'll pick this location ...also I'll pick code and weight from Excel 2 .

so new Excel will dump this data ..
New Excel:
---------------------
Location ------Code-----Weight
Paris 78 34


I have more than 15000 data in these excels which I need to compare and pick and have to put in a new excel through this logic. Please suggest me a workaround


I am a Excel user ...not an excel programmer. Can you suggest a solution from end user's perspective.

I'm using Office Version: 2007