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.