Search within a part of a column

[OBIPEDA]

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

 

[duane]

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, an
for a negative (not found) result for the

 

[Domenic]

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!