VLOOKUP ??

J

jay.gregerson

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
 
D

daddylonglegs

Assuming your list of names starts at A2 downwards on both sheets, results
has values in column B then in teams!B2 use this formula

=VLOOKUP(A2,results!A$2:B$100,2,0)

and copy down the column

adjust ranges as necessary
 
Top