If value matches value on another sheet then copy cell next to it into first sheet

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?

Yes, sorry should have said

I have 4000 rows in one sheet and about 5000 in the other and they are not in order. So I would like to match the relevant detail (BBQ number in this case) and then add the sell ranking into the first sheet that corresponds to the bbqnumber on the second. I have no idea why but I'm really struggling to articulate this well so apologies!

I'll give the below a go and let you know, thank you!

It didn't quite do the trick I'm afraid.

Attached is a spreadsheet with what I'm trying to achieve.
The items with the red background is where I need the formula. It should look up in sheet 2 and add the relevant sales rank number into sheet 1 'bestseller?' column.

Does that help at all?