"Neska" wrote:

I have a worksheet with three columns in the first column I have All the
entries for things that go up in one experiment (ex. BI879444). In the second
colum I have all the entries that were analaized an in the third column is
the related name for each entry. I want to multiple search all the values
from the first column in the second and mark them or sth like that any one
can help me. I do not now to much of excel so be patient

So I tried what you told me =IF(ISNUMBER(MATCH(A2,B:B,0)),"Y","")
So imagine I have in colum A 100 cells with data (ex BI879444) and in column
B this 100 data mixed with 1000 more. What will be the exact formula if it
start in A2. And what it means to search for Y. Sorry I do not know much
about excel. Thanks for your help