Search a value basing on another value
Col 'A' = Date
Col 'B' = Amount
I am looking for a function for: Search if there is current month's date
entry in Col'A', if found search for any entry in Col'B' of same row.If both
conditions are true "Paid" else "Payment Due".
Thanks to all Excel experts in advance.
|