+ Reply to Thread
Results 1 to 61 of 61

IF Statement Question

Hybrid View

  1. 09-06-2005, 07:05 AM #1
    Scott
    Guest

    Re: IF Statement Question

    Bob,

    This is SO close... the last bit might prove to be the most difficult part.

    That "B1" cell is actually going to be the cell in the same row that the
    name is found in column B. My check is IF "John Doe" is found in the range
    AND "X" is in the corresponding cell in column B THEN "Match", "No Match".

    (fingers crossed you know the answer)

    Thanks so much!

    Scott



    "Bob Phillips" wrote:

    > =IF(AND(COUNTIF(A1:A99,"John Doe")>0,B1="X"),"Match","No match")
    >
    > --
    > HTH
    >
    > Bob Phillips
    >
    > "Scott" <Scott@discussions.microsoft.com> wrote in message
    > news:6D36DCA0-BD8D-4F4E-BD83-B9A18862CA24@microsoft.com...
    > > This might be hard to explain...
    > >
    > > I want to check a sheet for a persons name AND if an X is entered in an
    > > associated cell. In literal terms the IF statement would be as follows:
    > >
    > > IF ("John Doe" is found in range A1:A99 AND there is an X in field B1,
    > THEN
    > > "OK")
    > >
    > > The X would appear in the same row as the name in the range, for example:
    > > Field A1 contains "John Doe" and field B1 contains "X".
    > >
    > > How would I make this work?
    > >
    > > Thanks,
    > >
    > > Scott
    >
    >
    >
    Reply With QuoteRegister To Reply
  2. 09-06-2005, 01:05 AM #2
    Scott
    Guest

    Re: IF Statement Question

    THAT WORKED!!!!!!!!

    THANK YOU SO MUCH!!!!!!!!!!!

    AWESOME!!!!!!!



    "Scott" wrote:

    > Bob,
    >
    > This is SO close... the last bit might prove to be the most difficult part.
    >
    > That "B1" cell is actually going to be the cell in the same row that the
    > name is found in column B. My check is IF "John Doe" is found in the range
    > AND "X" is in the corresponding cell in column B THEN "Match", "No Match".
    >
    > (fingers crossed you know the answer)
    >
    > Thanks so much!
    >
    > Scott
    >
    >
    >
    > "Bob Phillips" wrote:
    >
    > > =IF(AND(COUNTIF(A1:A99,"John Doe")>0,B1="X"),"Match","No match")
    > >
    > > --
    > > HTH
    > >
    > > Bob Phillips
    > >
    > > "Scott" <Scott@discussions.microsoft.com> wrote in message
    > > news:6D36DCA0-BD8D-4F4E-BD83-B9A18862CA24@microsoft.com...
    > > > This might be hard to explain...
    > > >
    > > > I want to check a sheet for a persons name AND if an X is entered in an
    > > > associated cell. In literal terms the IF statement would be as follows:
    > > >
    > > > IF ("John Doe" is found in range A1:A99 AND there is an X in field B1,
    > > THEN
    > > > "OK")
    > > >
    > > > The X would appear in the same row as the name in the range, for example:
    > > > Field A1 contains "John Doe" and field B1 contains "X".
    > > >
    > > > How would I make this work?
    > > >
    > > > Thanks,
    > > >
    > > > Scott
    > >
    > >
    > >
    Reply With QuoteRegister To Reply
  3. 09-06-2005, 07:05 AM #3
    Scott
    Guest

    Re: IF Statement Question

    THAT WORKED!!!!!!!!

    THANK YOU SO MUCH!!!!!!!!!!!

    AWESOME!!!!!!!



    "Scott" wrote:

    > Bob,
    >
    > This is SO close... the last bit might prove to be the most difficult part.
    >
    > That "B1" cell is actually going to be the cell in the same row that the
    > name is found in column B. My check is IF "John Doe" is found in the range
    > AND "X" is in the corresponding cell in column B THEN "Match", "No Match".
    >
    > (fingers crossed you know the answer)
    >
    > Thanks so much!
    >
    > Scott
    >
    >
    >
    > "Bob Phillips" wrote:
    >
    > > =IF(AND(COUNTIF(A1:A99,"John Doe")>0,B1="X"),"Match","No match")
    > >
    > > --
    > > HTH
    > >
    > > Bob Phillips
    > >
    > > "Scott" <Scott@discussions.microsoft.com> wrote in message
    > > news:6D36DCA0-BD8D-4F4E-BD83-B9A18862CA24@microsoft.com...
    > > > This might be hard to explain...
    > > >
    > > > I want to check a sheet for a persons name AND if an X is entered in an
    > > > associated cell. In literal terms the IF statement would be as follows:
    > > >
    > > > IF ("John Doe" is found in range A1:A99 AND there is an X in field B1,
    > > THEN
    > > > "OK")
    > > >
    > > > The X would appear in the same row as the name in the range, for example:
    > > > Field A1 contains "John Doe" and field B1 contains "X".
    > > >
    > > > How would I make this work?
    > > >
    > > > Thanks,
    > > >
    > > > Scott
    > >
    > >
    > >
    Reply With QuoteRegister To Reply
  4. 09-06-2005, 01:05 AM #4
    Bob Phillips
    Guest

    Re: IF Statement Question

    =IF(ISNUMBER(MATCH("John Doe",A1:A99,0)),IF(INDEX(B1:B99,MATCH("John
    Doe",A1:A99,0))="X","Match","No match"))

    --
    HTH

    Bob Phillips

    "Scott" <Scott@discussions.microsoft.com> wrote in message
    news:6722916F-072B-4F09-BB45-6292F4C6E9BE@microsoft.com...
    > Bob,
    >
    > This is SO close... the last bit might prove to be the most difficult
    part.
    >
    > That "B1" cell is actually going to be the cell in the same row that the
    > name is found in column B. My check is IF "John Doe" is found in the
    range
    > AND "X" is in the corresponding cell in column B THEN "Match", "No Match".
    >
    > (fingers crossed you know the answer)
    >
    > Thanks so much!
    >
    > Scott
    >
    >
    >
    > "Bob Phillips" wrote:
    >
    > > =IF(AND(COUNTIF(A1:A99,"John Doe")>0,B1="X"),"Match","No match")
    > >
    > > --
    > > HTH
    > >
    > > Bob Phillips
    > >
    > > "Scott" <Scott@discussions.microsoft.com> wrote in message
    > > news:6D36DCA0-BD8D-4F4E-BD83-B9A18862CA24@microsoft.com...
    > > > This might be hard to explain...
    > > >
    > > > I want to check a sheet for a persons name AND if an X is entered in
    an
    > > > associated cell. In literal terms the IF statement would be as
    follows:
    > > >
    > > > IF ("John Doe" is found in range A1:A99 AND there is an X in field B1,
    > > THEN
    > > > "OK")
    > > >
    > > > The X would appear in the same row as the name in the range, for
    example:
    > > > Field A1 contains "John Doe" and field B1 contains "X".
    > > >
    > > > How would I make this work?
    > > >
    > > > Thanks,
    > > >
    > > > Scott
    > >
    > >
    > >


    Reply With QuoteRegister To Reply
  5. 09-06-2005, 07:05 AM #5
    Bob Phillips
    Guest

    Re: IF Statement Question

    =IF(ISNUMBER(MATCH("John Doe",A1:A99,0)),IF(INDEX(B1:B99,MATCH("John
    Doe",A1:A99,0))="X","Match","No match"))

    --
    HTH

    Bob Phillips

    "Scott" <Scott@discussions.microsoft.com> wrote in message
    news:6722916F-072B-4F09-BB45-6292F4C6E9BE@microsoft.com...
    > Bob,
    >
    > This is SO close... the last bit might prove to be the most difficult
    part.
    >
    > That "B1" cell is actually going to be the cell in the same row that the
    > name is found in column B. My check is IF "John Doe" is found in the
    range
    > AND "X" is in the corresponding cell in column B THEN "Match", "No Match".
    >
    > (fingers crossed you know the answer)
    >
    > Thanks so much!
    >
    > Scott
    >
    >
    >
    > "Bob Phillips" wrote:
    >
    > > =IF(AND(COUNTIF(A1:A99,"John Doe")>0,B1="X"),"Match","No match")
    > >
    > > --
    > > HTH
    > >
    > > Bob Phillips
    > >
    > > "Scott" <Scott@discussions.microsoft.com> wrote in message
    > > news:6D36DCA0-BD8D-4F4E-BD83-B9A18862CA24@microsoft.com...
    > > > This might be hard to explain...
    > > >
    > > > I want to check a sheet for a persons name AND if an X is entered in
    an
    > > > associated cell. In literal terms the IF statement would be as
    follows:
    > > >
    > > > IF ("John Doe" is found in range A1:A99 AND there is an X in field B1,
    > > THEN
    > > > "OK")
    > > >
    > > > The X would appear in the same row as the name in the range, for
    example:
    > > > Field A1 contains "John Doe" and field B1 contains "X".
    > > >
    > > > How would I make this work?
    > > >
    > > > Thanks,
    > > >
    > > > Scott
    > >
    > >
    > >


    Reply With QuoteRegister To Reply
  6. 09-06-2005, 02:05 AM #6
    Scott
    Guest

    Re: IF Statement Question

    THAT WORKED!!!!!!!!

    THANK YOU SO MUCH!!!!!!!!!!!

    AWESOME!!!!!!!



    "Scott" wrote:

    > Bob,
    >
    > This is SO close... the last bit might prove to be the most difficult part.
    >
    > That "B1" cell is actually going to be the cell in the same row that the
    > name is found in column B. My check is IF "John Doe" is found in the range
    > AND "X" is in the corresponding cell in column B THEN "Match", "No Match".
    >
    > (fingers crossed you know the answer)
    >
    > Thanks so much!
    >
    > Scott
    >
    >
    >
    > "Bob Phillips" wrote:
    >
    > > =IF(AND(COUNTIF(A1:A99,"John Doe")>0,B1="X"),"Match","No match")
    > >
    > > --
    > > HTH
    > >
    > > Bob Phillips
    > >
    > > "Scott" <Scott@discussions.microsoft.com> wrote in message
    > > news:6D36DCA0-BD8D-4F4E-BD83-B9A18862CA24@microsoft.com...
    > > > This might be hard to explain...
    > > >
    > > > I want to check a sheet for a persons name AND if an X is entered in an
    > > > associated cell. In literal terms the IF statement would be as follows:
    > > >
    > > > IF ("John Doe" is found in range A1:A99 AND there is an X in field B1,
    > > THEN
    > > > "OK")
    > > >
    > > > The X would appear in the same row as the name in the range, for example:
    > > > Field A1 contains "John Doe" and field B1 contains "X".
    > > >
    > > > How would I make this work?
    > > >
    > > > Thanks,
    > > >
    > > > Scott
    > >
    > >
    > >
    Reply With QuoteRegister To Reply
  7. 09-06-2005, 02:05 AM #7
    Bob Phillips
    Guest

    Re: IF Statement Question

    =IF(ISNUMBER(MATCH("John Doe",A1:A99,0)),IF(INDEX(B1:B99,MATCH("John
    Doe",A1:A99,0))="X","Match","No match"))

    --
    HTH

    Bob Phillips

    "Scott" <Scott@discussions.microsoft.com> wrote in message
    news:6722916F-072B-4F09-BB45-6292F4C6E9BE@microsoft.com...
    > Bob,
    >
    > This is SO close... the last bit might prove to be the most difficult
    part.
    >
    > That "B1" cell is actually going to be the cell in the same row that the
    > name is found in column B. My check is IF "John Doe" is found in the
    range
    > AND "X" is in the corresponding cell in column B THEN "Match", "No Match".
    >
    > (fingers crossed you know the answer)
    >
    > Thanks so much!
    >
    > Scott
    >
    >
    >
    > "Bob Phillips" wrote:
    >
    > > =IF(AND(COUNTIF(A1:A99,"John Doe")>0,B1="X"),"Match","No match")
    > >
    > > --
    > > HTH
    > >
    > > Bob Phillips
    > >
    > > "Scott" <Scott@discussions.microsoft.com> wrote in message
    > > news:6D36DCA0-BD8D-4F4E-BD83-B9A18862CA24@microsoft.com...
    > > > This might be hard to explain...
    > > >
    > > > I want to check a sheet for a persons name AND if an X is entered in
    an
    > > > associated cell. In literal terms the IF statement would be as
    follows:
    > > >
    > > > IF ("John Doe" is found in range A1:A99 AND there is an X in field B1,
    > > THEN
    > > > "OK")
    > > >
    > > > The X would appear in the same row as the name in the range, for
    example:
    > > > Field A1 contains "John Doe" and field B1 contains "X".
    > > >
    > > > How would I make this work?
    > > >
    > > > Thanks,
    > > >
    > > > Scott
    > >
    > >
    > >


    Reply With QuoteRegister To Reply
  8. 09-06-2005, 03:05 AM #8
    Scott
    Guest

    Re: IF Statement Question

    THAT WORKED!!!!!!!!

    THANK YOU SO MUCH!!!!!!!!!!!

    AWESOME!!!!!!!



    "Scott" wrote:

    > Bob,
    >
    > This is SO close... the last bit might prove to be the most difficult part.
    >
    > That "B1" cell is actually going to be the cell in the same row that the
    > name is found in column B. My check is IF "John Doe" is found in the range
    > AND "X" is in the corresponding cell in column B THEN "Match", "No Match".
    >
    > (fingers crossed you know the answer)
    >
    > Thanks so much!
    >
    > Scott
    >
    >
    >
    > "Bob Phillips" wrote:
    >
    > > =IF(AND(COUNTIF(A1:A99,"John Doe")>0,B1="X"),"Match","No match")
    > >
    > > --
    > > HTH
    > >
    > > Bob Phillips
    > >
    > > "Scott" <Scott@discussions.microsoft.com> wrote in message
    > > news:6D36DCA0-BD8D-4F4E-BD83-B9A18862CA24@microsoft.com...
    > > > This might be hard to explain...
    > > >
    > > > I want to check a sheet for a persons name AND if an X is entered in an
    > > > associated cell. In literal terms the IF statement would be as follows:
    > > >
    > > > IF ("John Doe" is found in range A1:A99 AND there is an X in field B1,
    > > THEN
    > > > "OK")
    > > >
    > > > The X would appear in the same row as the name in the range, for example:
    > > > Field A1 contains "John Doe" and field B1 contains "X".
    > > >
    > > > How would I make this work?
    > > >
    > > > Thanks,
    > > >
    > > > Scott
    > >
    > >
    > >
    Reply With QuoteRegister To Reply
  9. 09-06-2005, 03:05 AM #9
    Bob Phillips
    Guest

    Re: IF Statement Question

    =IF(ISNUMBER(MATCH("John Doe",A1:A99,0)),IF(INDEX(B1:B99,MATCH("John
    Doe",A1:A99,0))="X","Match","No match"))

    --
    HTH

    Bob Phillips

    "Scott" <Scott@discussions.microsoft.com> wrote in message
    news:6722916F-072B-4F09-BB45-6292F4C6E9BE@microsoft.com...
    > Bob,
    >
    > This is SO close... the last bit might prove to be the most difficult
    part.
    >
    > That "B1" cell is actually going to be the cell in the same row that the
    > name is found in column B. My check is IF "John Doe" is found in the
    range
    > AND "X" is in the corresponding cell in column B THEN "Match", "No Match".
    >
    > (fingers crossed you know the answer)
    >
    > Thanks so much!
    >
    > Scott
    >
    >
    >
    > "Bob Phillips" wrote:
    >
    > > =IF(AND(COUNTIF(A1:A99,"John Doe")>0,B1="X"),"Match","No match")
    > >
    > > --
    > > HTH
    > >
    > > Bob Phillips
    > >
    > > "Scott" <Scott@discussions.microsoft.com> wrote in message
    > > news:6D36DCA0-BD8D-4F4E-BD83-B9A18862CA24@microsoft.com...
    > > > This might be hard to explain...
    > > >
    > > > I want to check a sheet for a persons name AND if an X is entered in
    an
    > > > associated cell. In literal terms the IF statement would be as
    follows:
    > > >
    > > > IF ("John Doe" is found in range A1:A99 AND there is an X in field B1,
    > > THEN
    > > > "OK")
    > > >
    > > > The X would appear in the same row as the name in the range, for
    example:
    > > > Field A1 contains "John Doe" and field B1 contains "X".
    > > >
    > > > How would I make this work?
    > > >
    > > > Thanks,
    > > >
    > > > Scott
    > >
    > >
    > >


    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1