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

[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!

In article <OBIPEDA.1qq8eb_1118937915.5529@excelforum-nospam.com>,
OBIPEDA <OBIPEDA.1qq8eb_1118937915.5529@excelforum-nospam.com> 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