Find record

M

MarkN

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

Stefi

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

Regards,
Stefi

„MarkN†ezt írta:
 
M

MarkN

Thanks very much,
Cheers,
MarkN


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

Regards,
Stefi

„MarkN†ezt írta:
Click to expand...
 
Top