Comparing 2 columns and then moving a third data point IF 2 other data points match

Comparing 2 columns and then moving a third data point IF 2 other data points match

--------------------------------------------------------------------------------

I have 2 sheets:

Sheet 1 – Customer First Name, Last Name and UNIQUE ID #.
Sheet 2 – Customer First Name and Last Name

I need to compare the sheets and anytime the first and last name match I need it to paste the ID # on sheet 2 where it does not exist.

Is this possible using a formula?

Again, teh ID is on 1 sheet and I need it moved to the other ONLY when the first and last name are identical as the sheet with the ID.

One way is to use a helper column of "FName,LName" values.
Attached doc shows this method using xl2003 formulas.
I have stuck with xl2003. I think the formula is simpler using xl2007's IFERROR function.

Beau Nydal