Hi,
see CPearson web, go to the middle of the page look for Extracting Elements
from One list not on another list

http://www.cpearson.com/excel/ListFunctions.aspx

if this helps please click yes thanks



"Janet" wrote:

User has two worksheets with names of employees for different years. She
wants to compare the worksheets with each other to see if between the two
years, anything has changed? Employees leaving, coming, etc. Which formula
would help her? Thanks