Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Dec 2002
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    (if and) formula not right (excell 2000)

    Hi, Can someone please tell me, whats wrong with this formula which is in D2 and copied down
    =IF(AND(A1=A2,B1=B2,C1=C2),"Match 1",IF(AND(A2=A1,B2=B1,C2=C1),"Match 2",""))
    the Titles are A1 Last Name B1 First Name and in C1 Date Of Birth.
    in A2 I have Smith B2 John C2 04/12/03 and in A3 to C3 is the same name and birthdate. I would like it to say in D2 "Match 2 and in D3 "Match 1.
    Thanks for any help. I don't know what I would do with out all the help from woody's lounge.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: (if and) formula not right (excell 2000)

    You will never get match 2 since your 2 ifs are the same: when A2=A1, A1=A2, etc.

    What criteria will give "match2"?, what criteria will give "match1"? Currently you check for the values in cols A-C in the current row match the values in the row above. for both.

    Steve

  3. #3
    2 Star Lounger
    Join Date
    Dec 2002
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: (if and) formula not right (excell 2000)

    Hi Thanks for getting back to me. I see the formula is wrong if its in D2. After making changes It works

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •