welcome to the board!!!
vlookup syntax (way the formula works)
=vlookup(cell to look at & match, range to lookup value in left-most column, column number in range to bring back, match type exact/close)
will find contents of a1 in column b (rows 1-50), find an exact match - the "0" on the end, and bring back the contents of the cell next to it in column c (the second column in your range).