Find text
 

Hi. I'm trying to find the text "V70.7" within a particular range - and if I
find it? Great.

I'm able to look in one particular cell - for example:

=IF(ISNUMBER(SEARCH("V70.7",AE33)),"incl V70.7","")

but I'm trying to look in the range - and or the individual cells of AE33,
AF33, AG33 -- through to AK33

I've tried to use OR but I've overcomplicated it or I don't understand how
to use it.

thought?

Find text
 

If the text is found, do you want the cell's contents or the cell's address??
--
Gary''s Student - gsnu200860


"beata" wrote:

Hi. I'm trying to find the text "V70.7" within a particular range - and if I
find it? Great.

I'm able to look in one particular cell - for example:

=IF(ISNUMBER(SEARCH("V70.7",AE33)),"incl V70.7","")

but I'm trying to look in the range - and or the individual cells of AE33,
AF33, AG33 -- through to AK33

I've tried to use OR but I've overcomplicated it or I don't understand how
to use it.

thought?

find text
 

just the fact that it's there - I don't care from which cell. thanks.

Find text
 

beata wrote:
Hi. I'm trying to find the text "V70.7" within a particular range - and if I
find it? Great.

I'm able to look in one particular cell - for example:

=IF(ISNUMBER(SEARCH("V70.7",AE33)),"incl V70.7","")

but I'm trying to look in the range - and or the individual cells of AE33,
AF33, AG33 -- through to AK33

I've tried to use OR but I've overcomplicated it or I don't understand how
to use it.

thought?


Maybe this array* formula:

=IF(MAX(--(ISNUMBER(SEARCH("V70.7",AE33:AK33)))),"incl V70.7")

*Commit the array formula by pressing Ctrl+Shift+Enter, not just Enter
or Tab.

Find text
 

=--(countif(ae33:ak33,"*"&"v70.7"&"*")0)
or
=--(countif(ae33:ak33,"*v70.7*")0)

Will return true (if it's there) or false (if it's not).

beata wrote:

Hi. I'm trying to find the text "V70.7" within a particular range - and if I
find it? Great.

I'm able to look in one particular cell - for example:

=IF(ISNUMBER(SEARCH("V70.7",AE33)),"incl V70.7","")

but I'm trying to look in the range - and or the individual cells of AE33,
AF33, AG33 -- through to AK33

I've tried to use OR but I've overcomplicated it or I don't understand how
to use it.

thought?

--

Dave Peterson

Find text
 

Thanks. While all three replies worked - I found this one the easiest.

"Dave Peterson" wrote:

=--(countif(ae33:ak33,"*"&"v70.7"&"*")0)
or
=--(countif(ae33:ak33,"*v70.7*")0)

Will return true (if it's there) or false (if it's not).

beata wrote:

Hi. I'm trying to find the text "V70.7" within a particular range - and if I
find it? Great.

I'm able to look in one particular cell - for example:

=IF(ISNUMBER(SEARCH("V70.7",AE33)),"incl V70.7","")

but I'm trying to look in the range - and or the individual cells of AE33,
AF33, AG33 -- through to AK33

I've tried to use OR but I've overcomplicated it or I don't understand how
to use it.

thought?

--

Dave Peterson