I stumbled across this forum and hope someone can help me, or tell me if it is possible?

I have spreadsheet 1 with product information, coloumn A is product number, coloumn B is product description,

I have spreadsheet 2 with product number in coloumn A and need to fill in coloumn B with the product descriptions from spreadsheet 1.

The issue I have is not all products are in spreadsheet 2, so I can't just sort by coloumn A and copy and paste.

Is there a way to do this quickly?

Many thanks for any advice,