You need to convert both sheets to a common format. I might suggest first
middle and last. Then the problem becomes relatively easy. You will need to
do text manipulation functions to make it work but assuming each sheet is
reasonably consistent then you should be able to work it out. One thing I do
in these cases is to remove all of the commas, dashes, etc using the find and
replace function to clean things up a bit. If you need help with the text
functions then just reply back...
--
HTH...

Jim Thomlinson


"hshayh0rn" wrote:

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???