I'm trying to figure out the best way to compare information on multiple
worksheets and return corresponding values across mulitple columns.

Here are the details:
Sheet 1 (530 people listed)
Column A contains last names
Column B contains first names
Column C blank
Column D blank

Sheet 2 (536 people listed)
Column A contains last names
Column B contains first names
Column C contains division
Column D contains group

What I want to do is compare first and last names on sheet 1 with first and
last names on sheet 2 - Then return the corresponding values from column C
and D on sheet 2 onto sheet 1.

Next, I would like to identify missing names from sheet 1.
--
Thanks,
GK