Results 1 to 5 of 5

conditional lookup for duplicate values

Threaded View

Abhi1687 conditional lookup for... 02-21-2013, 04:26 PM
rcm Re: conditional lookup for... 02-21-2013, 04:32 PM
Abhi1687 Re: conditional lookup for... 02-21-2013, 05:03 PM
rcm Re: conditional lookup for... 02-21-2013, 05:41 PM
Abhi1687 Re: conditional lookup for... 02-22-2013, 04:39 PM
  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

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