ExcelBanter - Linking data?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Linking data? (https://www.excelbanter.com/excel-worksheet-functions/230637-linking-data.html)

Ron_Ron

Linking data?

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.

[email protected]

Linking data?

On May 12, 5:07*pm, "Ron_Ron" <u51857@uwe wrote:
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.

Look into the VLOOKUP function.

Ken

Ron_Ron

Linking data?

wrote:
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.

Look into the VLOOKUP function.

Ken

Thanks Ken, that was the ticket.

All times are GMT +1. The time now is 12:53 AM.