I have what should be a simple process but just need a little guidance....

I have two sheets Call them Sheet1 and Sheet2 for the sake of this post...

In Sheet 1 I have a number of NAMES in column a and they correspond to a location in Column B In Column C there is a piece of data that is pulled from Sheet 2

IE:

Sheet1

Cell A1 = John Smith Cell B1 = Location1 Cell C1 = Sheet2$B1
Cell A2 = John Doe Cell B2 = Location 2 Cell C2 = Sheet2$B2
Cell A3 = Mike Jones Cell B3 = Location 1 Cell C1 =Sheet2!B1

Sheet 2
Cell A1= Location1 Cell B1=25
Cell A2 = Location2 Cell B2=33
Cell A3= Location3 Cell B3=45

What I am trying to do is... Make Sheet 1 Column C automatically Fill with the value from Sheet 2 Column B as long as the Value in Sheet 1 Column B matches the value in Sheet 2 Column A

Should be simple but looking for a quick solution....