Common Entries Between Lists

Old Chippy the formula you provided seems to work well...the other doesnt appear to function in the version of open office im using(dont have excel at work...)anyway....i have attached a file that shows my final issue....

when I do my second sort i am comparing multiple columns....you will see on sheet1 there are 3 columns (last, first, accountid) and sheet2 has 2 columns(last,first). I can combine the first and last name for matching purposes, but I would like for the account id to be shown on my new list on sheet3....is there an easy alteration to the formula to do this?

Thanks!!!!