You could create a pivot table instead, that would sum by email address the
values.

Jim wrote:
Hello,

Thanks in advance for the help.

Worksheet One - I have email address listed in column A with dollar amounts
listed in column B. These emails are listed multiple times, with different
amounts each time the email is listed.

Worksheet Two - In column A, I have the email listed once. I would like to
match the email from worksheet Two to all the occurrences in worksheet one
and sum the dollar amounts from column B.

Again, thanks for the help.
Jim

--
Matt Lynn

Message posted via http://www.officekb.com