Check if cell contains certain text
 

Hi All,

I'm looking for a function that can check to see if a cell contains specific text. For Example:

I have many cell that contain some, all, or none of the following 4-character text:
|C180|, |D410|, |S531|, |T844|
and I would like to know if, let's say D410, is contained in a certain cell. I will be checking for this in an array.

I also have another quick question. Is sumproduct or sum(if(.....)) quicker if they are both checking the same amount of criteria?

Thank you in advance,

Jason

Hi!

=ISNUMBER(SEARCH("D410",A1))

Will return TRUE if cell A1 contains the string D410. FALSE if it doesn't.

I also have another quick question. Is sumproduct or sum(if(.....))
quicker if they are both checking the same amount of criteria?

If you only have a single criteria use SUMIF first.

For multiple criteria use SUMPRODUCT first and usually, only if you have to,
use SUM(IF.

Biff

"jhockstr" wrote in message
...

Hi All,

I'm looking for a function that can check to see if a cell contains
specific text. For Example:

I have many cell that contain some, all, or none of the following
4-character text:
|C180|, |D410|, |S531|, |T844|
and I would like to know if, let's say D410, is contained in a certain
cell. I will be checking for this in an array.

I also have another quick question. Is sumproduct or sum(if(.....))
quicker if they are both checking the same amount of criteria?

Thank you in advance,

Jason


--
jhockstr

and if the D140 or what ever is not the only thing in the feald as ex

"d111 and d140"

you could use a variation

=ISNUMBER(FIND("d140";A3))

by the way smart move with the "isnumber"

;)


--
nijunge
------------------------------------------------------------------------
nijunge's Profile: http://www.excelforum.com/member.php...o&userid=26404
View this thread: http://www.excelforum.com/showthread...hreadid=398842