Find record
 

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

Find record
 

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

Find record
 

Thanks very much,
Cheers,
MarkN


"Stefi" wrote:

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

Find record
 

You are welcome! Thanks for the feedback!
Stefi

€žMarkN€� ezt Ã*rta:

Thanks very much,
Cheers,
MarkN


"Stefi" wrote:

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