In Sheet2!B2, enter:
=IF(COUNTIF(Sheet1!A:A,A2)0,"PRESENT","")
then drag down

HTH
--
AP

"sylink" a écrit dans le message de news:
...
Pls help with a macro to solve the task below:

Sheet1, column A has an unfixed or undetermined range of names
starting at "A2".
Sheet2 column A has a related name list also.
For every item in sheet2 column A, search through sheet1 Column A
Where a match is found, indicate "PRESENT" in the corresponding cell
in Sheet2 column B.