I have no idea how to search for this so apologies if this has been answered already

I have 2 sheets

Sheet 1 has product ID's in column B amongst other data in other columns
Sheet 2 has product ID's in column C and sell ranking in column A

I want to find the product ID that is showing in column B in sheet 1 on sheet 2 (column C) and then take the value in Column A sheet 2 and place it in sheet 1 column A

I'm not sure how well I have explained that so ill try to show it in numbers below

Before

Sheet 1
A, B, C,
Blank, BBQ1, xyz,
Blank, BBQ2, dfg,

Sheet 2
A, B, C,
1, ABC , BBQ1,
5, rty, BBQ2,

After

Sheet 1
A, B, C,
1, BBQ1, xyz,
5, BBQ2, dfg,

Sheet 2
A, B, C,
1, ABC , BBQ1,
5, rty, BBQ2,

Does that make anysense?