Index Match or Vlookup to return values?

I have a workbook with multiple sheet within it.

In Sheet 1, Column B, I want it to contain a name which is on another sheet. The problem is that The name is associated with a particular "location" number which is on a separate sheet.

The best I can explain:

On sheet 1 cell B2, I want excel to look at cell C2 to get the reference point then, look to sheet 2, cell A1 and where it matches sheet 1 cell B2, return the value from sheet 2 cell C1.

I have seen this done before using Index command but for the life of me, I cannot figure it out.

Could you post an example?

Sample spreadsheet.

This VLOOKUP function should help.
=VLOOKUP(C2,Sheet3!$A$2:$C$20,3)

That wold work if the list stayed the same but, the names and the locations could move on the list depending on who is handling them.

Here is the working model, you will see where it is not doing what I need it to do.

If you use VLOOKUP you need a final argument of FALSE or zero, i.e. in B2 copied down

=VLOOKUP(C2,BOB!$A$2:$C$61,3,0)

or you can use INDEX/MATCH like

=INDEX(BOB!$C$2:$C$61,MATCH(C2,BOB!$A$2:$A$61,0))

Thank You!!! That was what I needed.