+ Reply to Thread
Results 1 to 2 of 2

IF / AND Statement Question

Hybrid View

  1. 10-25-2011, 11:11 AM #1
    Rino468
    Rino468 is offline
    Registered User
    Join Date
    11-01-2010
    Location
    San Diego
    MS-Off Ver
    Excel 2007
    Posts
    38

    IF / AND Statement Question

    Hello all - i am in crisis mode again!
    Hopefull you can assist, this should be fairly simple.

    Formula Sheet:I have column A Row 4 on Sheet 1 that has product id (1234) and Row 5 is 12345 and Row 6 is 12346 etc...

    Data Sheet: In "Sheet 2" I have column A that has product ID's.

    in Column B (sheet 1) -- I basically want to compare the column A on both sheets (1 and 2) and if product ID matches - have it say "yes" and if it doesnt say "No" -- so Sheet 1 Row 5 (value 12345) has to be somehwere in Sheet 2 Column A for it to say "yes"

    I hope i made sense. I attached a sample.

    Thanks ahead of time.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-25-2011, 11:49 AM #2
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,846

    Re: IF / AND Statement Question

    Use this formula in Sheet1!B2 and copy down.

    =IF(COUNTIF(Sheet2!A:A,A2)>0,"FOUND","not found")

    Modify the result strings to suit.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]
    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