cell populate with corresponding match.

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

Guest

I have an excel sheet with two columns of importance one is names the other
is score. let's for uniformity's sake say name starts at A1 and score starts
at B1. In a set of different cells on the same sheet I will periodically put
a name from the name column, I want the score to populate in the cell right
next to it. How do I do it. Thanks in advance.
 
If your name is in C1 , enter this formula in D1:

=VLOOKUP(C1,A1:B200,2,FALSE)

Adjust B200 to your needs

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
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

Help with cell reference 3
Create if partial match then copy and paste data from one cell to another 1
Look up & auto populate between sheets 7
Index and match help 2
Finding Row and Column Numbers 4
Auto populating excel fields 3
Auto fill cell based upon another cell value 3
Splitting Equals 2

Back
Top