Using VLOOK to Match Data - Not Working As Expected

Hello-

I just realized a VLOOK I have been using is not working like I thought it was. I have attached an example that shows how I am matching a name in Column A with a name in Column C, and then pasting the value in Column B into column D.

You'll see that it's not working for "John." It appears that if a name in Column C appears in a higher row number that its match does in Column A, it won't work. Is there a way to make this work regardless of what rows the names are in? Thanks!