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