+ Reply to Thread
Results 1 to 5 of 5

conditional lookup for duplicate values

  1. #1
    Registered User
    Join Date
    12-21-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    21

    conditional lookup for duplicate values

    Hi Guys

    I have really complex situation would appreciate your help. In column “A” some values are repeated several times. And column “B” values could be different for each repeated value. Is there any way I can put a formula in column “C” based on below 3 conditions for example if cell A10,A11&A12 have duplicate values:

    Condition1: B10,B11&B12 has values between 1 to 3. C10,C11&C12 should all show “YES”.

    Condition2: B10,B11&B12 has values between 4 to 11. C10,C11&C12 should all show “NO”.

    Condition3: B10,B11&B12 has values between both sets(1 to 3 & 4 to 11). C10,C11&C12 should all show “NO”.

    Example file is attached
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: conditional lookup for duplicate values

    try this sample
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    12-21-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    21

    Re: conditional lookup for duplicate values

    Hi RCM

    thanks for your reply. i already tried all combinations of IF &AND/OR i can think of but nothing is giving the desired result. actually what i want to do is if the value in column a is repeated and for those each repeated value column b has different values. then i want column c to give result above mentioned 3 conditions.

  4. #4
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: conditional lookup for duplicate values

    try this macro
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    12-21-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    21

    Re: conditional lookup for duplicate values

    Cheers mate
    this is working exactly they way i wanted.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1