Merge Sheets without losing data

Hello all! This is my first time posting to this forum, so a big thanks in advance to all for your assistance. Hopefully I can accurately explain this:

I need a formula that can match the contents of column B on Sheet 1 to column B on Sheet 2. If a value from Sheet 1 matches a value from Sheet 2, then copy the same row value from column C on Sheet 2 to column C on Sheet 1.
Ex: IF Sheet1!B2 = Sheet2!B4 , THEN enter value from Sheet2!C4 into Sheet1!C2

I have two lists with one column that may contain duplicate values, that I need to merge without losing unique data from each.

I really think I could have explained this better, so apologies up front.

Thanks again!

Try

in Sheet1 column C

=IFERROR(VLOOKUP(Sheet1!$B2,Sheet2!$B$2:$B$100,2,0),"")

or

=IFERROR(INDEX(sheet2!$C$2:$C$100,MATCH(Sheet1!$B2,Sheet2!$B$2:$B$100,0)),"")

If a match in found for Sheet1 B2, then corresponding entry from Column C is returned,

Thank you, JohnTopley! I was able to use the second option, edited for my data set. This is great!

=IFERROR(INDEX(Sheet3!$J$2:$J$5000,MATCH(Master!$B2,Sheet3!$B$2:$B$5000,0)),"")