Newbie : Comparing two spreadsheets

  • Thread starter Thread starter Rich
  • Start date Start date
R

Rich

I am using Excel 97.

I need to compare two different worksheets. The worksheets represent
daily sales activity. Column A in both worksheets represents the
customer ID, Column B is product description and Column C is sales
amount.

If the Customer ID (Column A) in yesterday's data appears again in
today's worksheet, I am to compare the sales (Column C ). I am to
substract yesterday's sales from today sales. The new report is to
appear in another worksheet like the example below.

Customer ID Item Description Sales

1 Bonds $1,000,000
2 Stocks ($100,000)

Any ideas how to approach this problem.
 
Take a look at =Vlookup()

You can do something like this in column D:

=IF(ISERROR(VLOOKUP(A1,[book2.xls]Sheet1!A$1:C$999,3,FALSE)),0,
VLOOKUP(A1,[book2.xls]Sheet1!A$1:C$999,3,FALSE))

where book2.xls, sheet1, A1:c999 contained yesterday's numbers.

Then use column E to do your subtraction.
 
Back
Top