Matching ID numbers from different spread sheets

[Zavtacular]

I have two different spreadsheets, each contains a list of sample ID's (numerical) with data corresponding to each ID in the subsequent columns to the right. All of the ID's are in spreadsheet 1, and only some of them are in spreadsheet 2. I need to be able to transfer and match what ID's are present from spreadsheet 2 into spreadsheet 1, along with the information from the spreadsheet 2 columns next to the ID's. Any help with this issue would be greatly appreciated.


Thanks,
Zav

[arlu1201]

You can use vlookup. If all the IDs are in column A, in column B in spreadsheet 1, use this formula

=vlookup(A2,Sheet2!A:B,2,0)

considering that the data that you require is in Sheet2 column B of the same file.

[Zavtacular]

Thank you very much, I was able to use this. There are 2 columns of data next to the ID's in spreadsheet 2, how can you write a formula to bring multiple columns over.

Thanks so much!

[arlu1201]

Repeat the same formula, just change the range and the number of the column to be brought over.