Hi,

I need to match 1 columns data between 2 files and then calculate data in
another column between the 2 files.

Example:

FILE 1-2004 Data
Columns A B C
ROWS
Labels: Building Name Building Code Utility Cost
1
Data: Fox 11 1200 2
Bear 15 2300
3

FILE 2-2005 Data
Columns A B C
ROWS
Labels: Building Name Building Code Utility Cost
1
Data: New 87 450
2
New 1 88 1750
3
Fox 11 1900
4
Bear 15 2300
5

FILE 2 has new buildings added that year. I want to calculate the utility
cost between same buildings in both years.

Desired Result: Whats the difference between the Utility Cost for the Fox
Building during years 2004 and 2005? I want to quickly calculate 1900-1200.

What formula(s) would provide a quick and easy answer?

Many thanks for any replies.

Enjoy today.