Search a value basing on another value
Try this in C2:
=IF(AND(A2<"",MONTH(A2)=MONTH(TODAY())),IF(B2<"" ,"Paid","Payment
Due"),"")
Copy down as appropriate.
Hope this helps.
Pete
On May 22, 3:37*am, TUNGANA KURMA RAJU
wrote:
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.
|