Provided names in Sheet2 are also in column C
=VLOOKUP(C2,Sheet1!C:J,8,FALSE)

Regards,
Stefi

€žMarkN€� ezt Ã*rta:

Hello,

Sheet1 has a list of unique names in column C and comments in column J.
Sheet2 has some of the same names in a different order. How do I go about
creating a formula on Sheet2 that finds the name on Sheet1 and inserts the
appropriate comment?
--
Any help appreciated,
MarkN