Searching a value with in a cell range

  • Thread starter Thread starter Mario
  • Start date Start date
M

Mario

Is there a way to search if a text occurs in range of
cells. I know there is a "SEARCH" fucntion., it searches
if a text occurs in part of another text. But, that is
not what I am looking for.

The function I am looking for would be similar to:
=FindInRange(A3,B3:B10,1)
That is I want to find if A3 occurs in any part of cells
B3:B10.

If I have write my function, in case of non-availability
of built in functions, can any of you please help with
VBA.

Please help.

Thanks
 
Hi
sorry, typo. Make this
=IF(COUNTIF(B3:B10,"*" & A3 & "*")>0,"in range","not in range")
 
My god, you are a genius.

Now I'm getting a little bit more ambitious. Is there a
way to find in which row its occuring. Ideally I am
interesting showing the value of the column C in the row
at which that value occurs instead of displaying the
message "inrage".

Thanks
 
Back
Top