View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paresh[_2_] Paresh[_2_] is offline
external usenet poster
 
Posts: 3
Default How do I compare two sheets and output a report?

Scenario:
Sheet 1 has 500 entries with the columns Last Name, First Name, Email Address
Sheet 2 has 3000 entries with the columns Buddy Name, Last Name, First Name,
IM Platform

Problem:
I need to compare Sheet 1 against Sheet 2 for matches between the First and
Last name. Where it finds a match I need to correlate the Buddy Name with
that person in some fashion (i.e. say on Sheet 3 output Rob Smith,
, hotdog23, MSN)

Any help would be greatly appreciated