Can you post a small example?

If you data looks like this:

Column A

45
1
84
99
8

Column H

1,12,20
32,44,55
18,99,65

In column B enter this formula and copy down:

=IF(SUMPRODUCT(--(ISNUMBER(FIND(","&A1&",",","&H$1:H$3&",")))),"mat ch","")

Column B will return "match" for 1 and 99

Biff

"Dave" wrote in message
...
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