Here's my data table - Starts in A1 (Sheet1)

Type Code
9P170.00 RI
9P170.00 RI
9P160.00 RI
9P160.00 RI
9P150.00 SI
9P150.00 SI
9P140.00 RI
9P140.00 RI

I am trying to create this table - Starts in A1 (Sheet2)

Type Code
9P170.00 RI
9P160.00 RI
9P150.00 SI
9P140.00 RI


So. I am trying to find a formula for B2:B5 that will look at A2:A5 (Sheet2)
find the match in A2:A8 (Sheet 1) and if a match is found, return value in
B2:B8 (Sheet1). If no match is found, return "No Match".

Thank you in advance.