Can I search a client and his payment to decide Paid or Unpaid in his statement

[Jihad72]

Dear All Excel Experts
I have my sheets: Clients, Payments, Statement
In the Statement sheet I tried my best that Excel automatically looks for the payment of the client and decides "Paid" or "Unpaid", but in vain.
I have hope that experts will help my solve this problem.
By the way the payment is the same number of the invoice amount; client has many invoices and many payments
File is attached looking for your help on this link:

https://www.officena.net/ib/topic/8...واضافة-مدفوع-او-غير-مدفوع-في-جدول-كشف-الحساب/



Jihad

 

[ravishankar]

can't download your file. it is possible to do it. we need to know which columns of which sheet needs to be compared to decide if it is paid or not\
ravi shankar