Lookup Brain Twister!
Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Lookup Brain Twister!

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    232
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I'm having trouble getting my head around this one....

    Col A is the number, Col B is the Code, Col 3 is a flag.

    What I want to do is if the code = SLMON MEDIA or SLMONSTER is in Col B look at the number next to it in Col A and tell me if that number appears in the list.

    A clearer example is 293957 has SLMON MEDIA and SLREV against it, becasue SLMON MEDIA is there I don't want to see it. If if just had SLREV I do want to see it.

    Thanks in advance
    Matt

    293950__SLTRAD PROD 1
    293952__SLTRAD PROD 1
    293955__SLTRAD PROD 1
    293955__SLTRAD PROD 1
    293956__SLMON MEDIA 2
    293957__SLMON MEDIA 2
    293957__SLREV 1
    293957__SLTRAD PROD 1

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    232
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    sorry to bring back to the top... anyone have an idea?

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    can you make it a bit clearer what you want excel to do ?

    do you want it to tell you something or do you want it to hide something ?

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Calgary, Alberta Canada
    Posts
    3,329
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default


    I am not sure what you require.

    You can consider

    =IF(B3=B2,B3,"")

  5. #5
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    On 2002-03-20 05:43, mrowe wrote:
    I'm having trouble getting my head around this one....

    Col A is the number, Col B is the Code, Col 3 is a flag.

    What I want to do is if the code = SLMON MEDIA or SLMONSTER is in Col B look at the number next to it in Col A and tell me if that number appears in the list.

    A clearer example is 293957 has SLMON MEDIA and SLREV against it, becasue SLMON MEDIA is there I don't want to see it. If if just had SLREV I do want to see it.

    Thanks in advance
    Matt

    293950__SLTRAD PROD 1
    293952__SLTRAD PROD 1
    293955__SLTRAD PROD 1
    293955__SLTRAD PROD 1
    293956__SLMON MEDIA 2
    293957__SLMON MEDIA 2
    293957__SLREV 1
    293957__SLTRAD PROD 1
    Hi,

    In column 3 (I am starting in row 3), try
    =IF(OR(B3="SLMON MEDIA",B3="SLMONSTER"),A3,"")
    and copy down your list

    The hardcoding of the lookup names can be references, too.

    HTH,
    Jay

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com