Search a value basing on another value

T

TUNGANA KURMA RAJU

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.
 
J

jlclyde

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.
Click to expand...

If you are looking for an actul search then you will ahve to do this
by putting in a little code. If not you can copy this into a
worksheet and it should give you the answer.
=IF(AND(MONTH(A21)=MONTH(TODAY()),MONTH(TODAY())=MONTH(B21)),"Paid","Payment
Due")

Hope this helps,
Jay
 
T

TUNGANA KURMA RAJU

Mr.jlclyde,
Col"b" is a numeric value,not a date.please read my question thoroughly.
yuor formula is entirely wrong.
 
P

Pete_UK

Try this in C2:

=IF(AND(A2<>"",MONTH(A2)=MONTH(TODAY())),IF(B2<>"","Paid","Payment
Due"),"")

Copy down as appropriate.

Hope this helps.

Pete
 
T

TUNGANA KURMA RAJU

thanks pete.its working fine

Pete_UK said:
Try this in C2:

=IF(AND(A2<>"",MONTH(A2)=MONTH(TODAY())),IF(B2<>"","Paid","Payment
Due"),"")

Copy down as appropriate.

Hope this helps.

Pete
Click to expand...
 
Top