Hello,
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,
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,