Search within a part of a column
 

Hello!
I got a small question, which should not be any problem for a Excel
specialist.

I want to search through a part of a column (i.e. "E200:E250") for a
specific text (i.e. "P"), and if in one cell of the specified range
exactly this text is found, I want to set a seperate text (i.e. "B") in
another cell (i.e. "E255).

Has anyone of you some idea for me?

I tried like =if(E200:E250="P"; "B"; ""), but is not working!

Best regards,
Peter


--
OBIPEDA
------------------------------------------------------------------------
OBIPEDA's Profile: http://www.excelforum.com/member.php...o&userid=24373
View this thread: http://www.excelforum.com/showthread...hreadid=379654

try this

=IF(SUMPRODUCT(NOT(ISERROR(SEARCH("p",e200:e250,1) ))*1)0,5,6)

substitute what you want for a positive (found) result for the 5, and
for a negative (not found) result for the 6


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=379654

Try...

=IF(COUNTIF(E200:E250,"P"),"B","")

Replace commas with semi-colons if your version of Excel uses the
semi-colon as a list separator.

Hope this helps!

In article ,
OBIPEDA wrote:

Hello!
I got a small question, which should not be any problem for a Excel
specialist.

I want to search through a part of a column (i.e. "E200:E250") for a
specific text (i.e. "P"), and if in one cell of the specified range
exactly this text is found, I want to set a seperate text (i.e. "B") in
another cell (i.e. "E255).

Has anyone of you some idea for me?

I tried like =if(E200:E250="P"; "B"; ""), but is not working!

Best regards,
Peter