=countif(sheet2!a:a,"*"&a1&"*")0

Will return True if it's found.

You may want to check for empty cells:
=if(a1="","",countif(sheet2!a:a,"*"&a1&"*")0)

or

=isnumber(match("*"&a1&"*",sheet2!a:a,0))
or
=if(a1="","",isnumber(match("*"&a1&"*",sheet2!a:a, 0)))





Dave wrote:

I am looking to produce a formula that shows if a number is "found" or "not
found".
I have list of over 1000 numbers in one column (1 number per row) . I am
trying to identify if those values are present in a range of numbers from
another worksheet(also in a single column). My challenge is that the range of
numbers that I am looking in has multiple values, separated by commas in a
single cell. Looks like it was from an Access data dump. Any help is
appreciated.
--
dmp

--

Dave Peterson