Find record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Provided names in Sheet2 are also in column C
=VLOOKUP(C2,Sheet1!C:J,8,FALSE)

Regards,
Stefi

„MarkN†ezt írta:
 
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...
 
You are welcome! Thanks for the feedback!
Stefi

„MarkN†ezt írta:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

EXCEL - IF(IFERROR(VLOOKUP question 0
match first and last name and insert column into existing sheet 1
Pull Data from one sheet to another 1
How Do I Avoid #REF! In Formulas? 4
Complex Look up 2
Sum Data if Column B = Q 3
Sum If function 3
Need Improved String Formula 9

Back
Top