Lookup Brain Twister!

mrowe · Mar 20th, 2002, 06:43 AM

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 · Mar 20th, 2002, 07:14 AM

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

Chris Davison · Mar 23rd, 2002, 09:24 AM

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 · Mar 23rd, 2002, 09:45 AM

I am not sure what you require.

You can consider

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

Jay Petrulis · Mar 23rd, 2002, 06:07 PM

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 20th, 2002, 06:43 AM	#1
mrowe Board Regular Join Date: Feb 2002 Posts: 232	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

Mar 20th, 2002, 07:14 AM	#2
mrowe Board Regular Join Date: Feb 2002 Posts: 232	sorry to bring back to the top... anyone have an idea?

Mar 23rd, 2002, 09:24 AM	#3
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	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 ?

Mar 23rd, 2002, 09:45 AM	#4
Dave Patton Board Regular Join Date: Feb 2002 Location: Calgary, Alberta Canada Posts: 2,065	I am not sure what you require. You can consider =IF(B3=B2,B3,"")