Worksheet 1 has columns A & B which contain a sorted list of last names and
first names.

Worksheet 2 has columns A, B, & C. Columns A & B contain a sorted list of
last names and first names which is a subset of the list in worksheet 1.
Column C is a count value.

I would like to merge worksheets 1 & 2 to create worksheet 3 which contains
a count value for every case where the last name-first name in worksheet 1
matches the last name-first name in worksheet 2, or zero where there is no
match.

This essentially an SQL join of worksheets 1 & 2 on Last Name and First Name.

Can I do this in Excel? Anybody know how? Thanks.

you only want to count when both names match ,,, or when each surname \ first
name match

"Michael Ryle" wrote:

Worksheet 1 has columns A & B which contain a sorted list of last names and
first names.

Worksheet 2 has columns A, B, & C. Columns A & B contain a sorted list of
last names and first names which is a subset of the list in worksheet 1.
Column C is a count value.

I would like to merge worksheets 1 & 2 to create worksheet 3 which contains
a count value for every case where the last name-first name in worksheet 1
matches the last name-first name in worksheet 2, or zero where there is no
match.

This essentially an SQL join of worksheets 1 & 2 on Last Name and First Name.

Can I do this in Excel? Anybody know how? Thanks.