I have a list of names with duplicates in column A of sheet 1 and related
info in columns B & C . I have a second list in column A of sheet 2
containing some of those names and additional related info in subsequent
columns that is different from the info on the 1st sheet. What I'm trying to
accomplish is taking each value from the 1st sheet, compare it to the list on
the 2nd sheet and once a match is found, copy the additional info from
columns B,C & D on sheet 2 to columns D, E, & F on sheet 1, essentially
merging the 2 sheets.

Using Excel 2007 and have tried Vlookup with a nested match and index with a
nested match but formula fails (#N/A for table array). Can someone point me
in the right direction or point out what I'm failling to see. Thanks in
advance for your assistance.