Thread: Find text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
beata beata is offline
external usenet poster
 
Posts: 19
Default 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?