Thread: Linking data?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron_Ron Ron_Ron is offline
external usenet poster
  
Posts: 2
Default 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.

Reply With QuoteReply With Quote