Excel 2007 : Find and replace loop

Hello
I have 2 spreadsheets, 1 sheet has a list of suppliers that match up with the corresponding product. For instance the sheet looks like this ( ID Supplier Name Product Name)

What im trying to do is take the suppliers list and replace the supplier name with the id number from the supplier list.

Two different sheets i need to basically find and replace the supplier ID number from the supplier sheet to the product supplier column.

Is this possible?