Kimberly
You say:
I would like the results in column I (the lookup) and J (sum of the values).
Of what row? The row of the Column A item or the row of the Column E item?
Also, what is the "the lookup" that you want in Column I? I take the "sum
of the values" to mean the difference that you want calculated. FYI, I plan
on writing a macro to do this. Otto
"Kimberly" wrote in message
...
Thanks so much for the quick response, Otto!
To answer your questions -
yes, "subtract the value in Column D, in the row of the Column A item,
from
what's in Column H in the row of the same item found in Column E"
I would like the results in column I (the lookup) and J (sum of the
values)

yes - items in A should only occur once in column E


"Otto Moehrbach" wrote:

You want to take every value in Column A and find a match of that value
anywhere in Column E, if it's there. If it is there, you want to
subtract
the value in Column D, in the row of the Column A item, from what's in
Column H in the row of the same item found in Column E. Is that right?
Question: Where do you want the result of the subtraction to be placed?
Another question: Do the items in Column A appear, if at all, only once
in
Column E. If they appear more than once, what do you want to do with
each
one? HTH Otto
"Kimberly" wrote in message
...
Microsoft 2003 - I have to compare data extracted from one application
to
data extracted from another application and resolve all discrpancies
between
the two files. Any ideas on how to do this?
The file has 8 columns - 4 from one application and 4 from the other
application (columns a1:d55 is company "XYZ", columns e1:h500 is
company
"ABC"). I need the formula to subtract the contents of column 'd' from
column 'h' where contents of column 'a' are found in column 'e'. These
are
not always on the same row. Sometimes the match occurs on row one of
column
'a' and row three of column 'e'. In addition it is also possible that
no
match is found at all. Any suggestions would be appreciated. Thanks.