Home |
Search |
Today's Posts |
#1
|
|||
|
|||
cell populate with corresponding match.
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. |
#2
|
|||
|
|||
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 "cherrynich" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Populate a cell | Excel Discussion (Misc queries) | |||
make a cell automatically populate with "1" when specified cell va | Excel Discussion (Misc queries) | |||
Formatting a cell to populate on a certain date | Excel Worksheet Functions | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |