Compare and Calculate Data Between 2 Files

[Guest]

Hi,

I need to match 1 column’s 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: What’s 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.

 

[Guest]

Assuming you name the range in File1 Data2004, use the following in column D
(or desired location) of the 2005 Data file and copy down.

A1-VLOOKUP(A1,File!Data2004,3,FALSE)