formula..that tells me if any given cell has "510"

**Chrisnelsonusa** · 05-01-2009, 04:51 PM

I have a cell that contains the following text:

PDP-510dp
DLPRP-1020
PDP-560drp

and other pieces of data similar to that.

How can I write an equation that tells me if any given cell has "510" in it?

**martindwilson** · 05-01-2009, 05:05 PM

if you are just checking cell by cell
=IF(ISERROR(FIND(510,A1)),"not found","found")

**Chrisnelsonusa** · 05-01-2009, 05:19 PM

That worked great, what if I asked then to find multiple different pieces of information. Say 510, 520, 1080, etc.

Don't you hate when you answer a question and then they continue the question with what they really needed to know? I know I can nest the equations, looking for a more complete answer than nesting multiple equations though.

**VBA Noob** · 05-01-2009, 05:33 PM

Don't you hate when you answer a question and then they continue the question with what they really needed to know?

Chrisnelsonusa,

We do so please don't do it again.

PS. Please read the forum rules below as I had to amend you're title

VBA Noob

**martindwilson** · 05-01-2009, 05:35 PM

well youre stuck with nesting (unless someone cares to write a bit of code/udf)but you could reference other cell swith the values in to save re writing the equations.
=IF(OR($D$1="",$E$1=""),"",IF(ISERROR(AND(FIND($D$1,A1),FIND($E$1,A1))),"not found","found"))
where d1 and e1 contain the values that must both be in cell a1