Formula to match contents of column B to Column A and bring back corresponding data from column C

[Robert_Conklin]

Can someone help me with a formula that will match a cell in column B to a cell in Column A and if they match then bring back the corresponding data from column C?

 

[AlanY]

=index(c:c,match(b1,a:a,0))

 

[mikerickson]

Or
=VLOOKUP(B1, A:C, 3, False)

 

[Robert_Conklin]

Thank you gentlemen for the quick response! Mike, your formula worked like a champ. Thanks a million!