Lookup Brain Twister!

[mrowe]

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

 

[mrowe]

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

 

[Chris Davison]

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 ?

 

[Dave Patton]

I am not sure what you require.

You can consider

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

 

[Jay Petrulis]

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