There are two excel sheets I'm working on. The first is made up of 300 names of programs, one each row, and with 2 additional columns with version numbers and extra info. The second is a lot alike, but has about 100 rows and has 2 columns with different information from the first.
Adobe premiere , 6.0.2, video-editing software
Around 50 of these programs match by name (they are both in sheet 1 and 2), and i would like to import extra information about all matching programs from sheet 2 into sheet one, next to the existing information. That would mean that 50 or so rows have 2 additional columns and that about half of sheet 2 is left unmatched.
By hand, this means copying the names from sheet 2, finding a match in sheet one, then copying the 2 columns from sheet 2 and pasting them in the corresponding location in sheet 1. I hope there might be a better way to do this. Does anyone know a way?
Any help is appreciated.