Lookup and match to check for zeros

[PierremontQuaker03]

Hi, thanks for looking.
I am looking to review my goods received not invoiced account.
Essentially everything being posted in at one value should go out at the same value.
So what I am wanting to do is using the reference in Column E in the attached files, is to look up the Document number, check the rest of the rows for that document number and subtotal all of those values (column H) - in theory the total should be zero, if the value is zero, then in column BE where I want the formula to sit, I want to say "Cleared", and if it is not zero then I want it to return the value of the difference.

 

[vletm]

PierremontQuaker03
Two samples
> yours BE
> other BF (shorter)

 

[PierremontQuaker03]

Brilliant thank you, what if I wanted to add in another condition to the formula? If the answer to the current formula is not zero, then can it do the same process with column AZ (Sales Order No.) Is there anyway if I can add this into the formula. Obviously if the Sales Order No. is blank then it can ignore this check. Many thanks

 

[vletm]

Many things are possible ... and ... it would be smoother to give all conditions same time.
Your 'add' could be this ... or something like this ... You maybe missed some vital information.
You can edit it as You need.

 

[PierremontQuaker03]

Thank you