Comparing two worksheets
 

I need to compare two worksheets to derive the accurals of purchas orders and
invoices. I can find the lines and copy them if they are actually in just one
of the worksheest. My problem is that I am searching for invoice numbers
whiere the same number can appear more than once on both worksheets and in
some instances the invoice will only be partly paid so there is a difference
in the values in the purchase order side caompared with the same invoice
numbers in the Invoice side. I need to be able to capture the difference and
put that difference into the accurals worksheet. I tired to use vlookup, but
it only finds the first of any matchiong value and therefore does not returns
all of the line values if there is more than one.

Any help most appreciated.

Regards

alathwell

Comparing two worksheets
 

Check out help on

=SUMIF()

--
Jacob (MVP - Excel)


"alathwell" wrote:

I need to compare two worksheets to derive the accurals of purchas orders and
invoices. I can find the lines and copy them if they are actually in just one
of the worksheest. My problem is that I am searching for invoice numbers
whiere the same number can appear more than once on both worksheets and in
some instances the invoice will only be partly paid so there is a difference
in the values in the purchase order side caompared with the same invoice
numbers in the Invoice side. I need to be able to capture the difference and
put that difference into the accurals worksheet. I tired to use vlookup, but
it only finds the first of any matchiong value and therefore does not returns
all of the line values if there is more than one.

Any help most appreciated.

Regards

alathwell