I have two very large related data sets. The data in set #1 contains certain data about a large number of pipes. Data set #2 contains different information about the same pipes. Each pipe is represented by the same ID # in both data sets. I need to get certain data about each pipe but some of that data is in data set #1 and the rest of it is in data set #2. What I need to do is link up each pipe's data in set#1 to that same pipe's data in set #2 so I can then extract the information I need. Both data sets are ordered differently and since there are so many pipes it is impossible to just search each pipes ID# and record the information I need. Is there anything that I can do in excel that will link each pipes info from both data sets all in one spot together since that ID# is the same in both sets? Thank you!