Bringing Back Data from one worksheet to another
 

Hi,

I have been asked to match some data from one worksheet to another and I can't work out how to do it.

In a nutshell.

in one worksheet I have a column with product ID and next to it the manufacturer, in another I have a column of Product ID that we have sold, but I need to create a blank column named 'Manufacturer' and this should match up the data from the first worksheet.

Does this make sense and can anyone help?

1st worksheet

Prduct ID Manufacturer
1 Dunn
2 Merry
3 Christmas
4 Excel
5 Help

2nd worksheet

Product ID Manufacturer
2 ?
3 ?
3 ?
4 ?
5 ?