title: Find Partial Matching data across two sheets
body: <p>I have two excel sheets that I am working with.  Sheet 1 has a 'last name' column D and sheet 2 has a 'name' column A.  the 'name' column contains last,first name so I need a partial match option to find the customers last name in each sheet and create a new list using the information found in the 'name' column A from sheet 2 in another sheet.  This may be simple but for someone who lacks in excel I would appreciate the help.</p>