I have two worksheets in an Excel workbook.

Sheet1 has a prize designation column with different prizes i.e. WM20, WM10,
etc

Sheet2 has the prize designation (WM20) matched with a name i.e. Walmart
giftcard

I need to display the name from sheet2 in a column on sheet1?

Thanks