if cells in Column A sheet1 and Column A sheet2 match, return text from same Sheet1 row

In a workbook, I have two sheets which have slightly different lists, Sheet 1 and Sheet 2. Each sheet has a list of Products. The Products are listed in Column A of Sheet one and Column A of Sheet two. There's overlap, but some Products will be in one sheet and not in the other and vice versa. Both sheets have a second column, called Code. The Code list gets entered into Sheet 1 on the corresponding Product row.

What I want to do is fill Column B of Sheet 2 with the correct Product.


Sheet 1

A...............B
bees.........animal
karaoke.....entertainment
paisley......pattern


Sheet 2

A...............B
karaoke......
mercury.....
bees.........

Apologies for being a tyro and thanks for any help!

Put this formula in B1of Sheet2:

=IFERROR(VLOOKUP(A1,Sheet1!A:B,2,0),"")

Then copy down.

Hope this helps.

Pete

Thanks Pete, that works! Much appreciated.