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