Linking data?

R

Ron_Ron

I have one sheet with a list of ID numbers and there corresponding names. In
another sheed I have 100,000+ rows of data that contain the ID number as well
as other data. Is there a way to add the names that correspond to the ID
with out doing it one at a time?

Thanks.
 
K

krcowen

I have one sheet with a list of ID numbers and there corresponding names. In
another sheed I have 100,000+ rows of data that contain the ID number as well
as other data.  Is there a way to add the names that correspond to the ID
with out doing it one at a  time?

Thanks.
Click to expand...

Look into the VLOOKUP function.

Ken
 
Top