Search a value basing on another value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TUNGANA KURMA RAJU - 22 May 2008 03:37 GMT

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.

Reply to this Message

jlclyde - 22 May 2008 07:44 GMT

On May 21, 9:37 pm, TUNGANA KURMA RAJU
<TUNGANAKURMAR...@discussions.microsoft.com> 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.

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

Reply to this Message

TUNGANA KURMA RAJU - 22 May 2008 10:44 GMT

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

> On May 21, 9:37 pm, TUNGANA KURMA RAJU
> <TUNGANAKURMAR...@discussions.microsoft.com> wrote:
[quoted text clipped - 13 lines]
> Hope this helps,
> Jay

Reply to this Message

Pete_UK - 22 May 2008 13:06 GMT

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
<TUNGANAKURMAR...@discussions.microsoft.com> wrote:

Reply to this Message

TUNGANA KURMA RAJU - 23 May 2008 02:26 GMT

thanks pete.its working fine

> Try this in C2:
>
[quoted text clipped - 15 lines]
> > conditions are true "Paid" else "Payment Due".
> > Thanks to all Excel experts in advance.

Reply to this Message