Results 1 to 2 of 2

IF / AND Statement Question

Threaded View

  1. #1
    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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1