I have 2 spreadsheets that I need to compare and then grab data from one of
them if I find a match. That's great is the data in each sheet matches but I
have to deal with two different companies inputing data on each sheet so the
data is rarely in the same format. For example:

Sheet #1
Name Title
Bob Smith AVP Marketing
Jane Smith CEO
Tim Thomas VP

Sheet #2
Name
Smith, Bob
Jame Smith
Thomas Tim

If a name from coulmn A on sheet two match the names from column A on sheet
one then I need to populate column B on sheet 2 with the person's title.
There's no way for me to control how the data is input by the companies. I
can not control frist, last or last, first or the use or non-use of a middle
initial.

Can someone please help me with some code to figure this problem out???