First I must say that your site is great and it helps me a lot.

Can you explaine to me how to do search in Excel ?

explenation:

I have 2 sheets on the same excel file. I need to search one column in the
2nd sheet and if i found the data I look for then I need excel to put this
data in the first sheet on the same raw when the data is equel to.

example:
1. on sheet 1 I have names of people.
2. on sheet 2 I have a cloumn that contains some of the names from sheet 1.
3. I need excel take each raw in sheet 1 and search sheet 2 for the same
name.
4. if it found the same name in sheet 2 then it will write on sheet 1 "OK"
if it does not find it it will write "NO"

Any ideas how to do that ?

Thanks,
David