New to VLOOKUP's here- Read the tutorial but not making sense.
Here's my question

I have a list of names on and excel sheet called "teams"
Mary
John
randy
Jim

I have another sheet called "results" with the same names but in a different
order
John 12
Jim 13
Mary 11
Randy 10

I'd like the first work sheet to look at the 2nd work sheet and find the
corrisponding name- and copy the value to the first work sheet.

Hope that makes sense-

Thanks for looking