Find matches in 2 sheets and append the data from each row where there is a match to sheet 1

[lazzareo]

I have to separate Excel spreadsheets:

• Spreadsheet 1 - contains columns A-K with column A containing a unique ID
• Spreadsheet 2 - contains columns A-AD with column B containing a unique ID

What I want to be able to do is compare the 2 spreadsheets and find any match of the unique ID when comparing column A in sheet 1 and column B in sheet 2. I then want to append the data in the matching row of sheet 2 (A-AD) to the row where there is a match in Sheet 1 from column L.

This will give me all the relevant data relating to each unique ID in sheet 1.

I could do this manually however sheet 1 has 1700 rows and sheet 2 has 700 rows so it would take some time.

Although, what I am asking might be impossible.

Thanks

 

[sunny102]

I guess you want to append the data from sheet1 to sheet 2, so sheet 2 will have 5 extra columns if there is a match i.e., AE (L from Sheet1), AF (M from Sheet1) and so on, Is it correct? Also, of you can share your sheet here, it'll help me in understanding your requirement clearly

 

[lazzareo]

Hi, almost correct. I want to append the data from sheet2 to sheet1 where there is a match so there will be 30 extra colums in sheet 1 (A-AD from sheet2).

Unfortunately I can't upload the sheets due to the content.