That's easy with a VLOOKUP-formula.

Adding the 2011-only customers to the table-of-all-customers is much more difficult.

Kees