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
Jihad
شكرا للرد اخي عماد
لكنني حاولت استخدام Search, if, sum وغيرهم
لكنني لم اصل الى النتيجة المطلوبة
فاضطررت اخيرا الى وضع data validation للقيمتين Paid, Unpaid
اذا امكن تعملها انت، اكون شاكر كثيرا