How to lookup a value between 2 sheets in same workbook

[rskip]

I have 2 sheets:
Sheet 1 has a list of names in random order in column A, such as:
Bill
Alex
Denzil
Colin

I want place a value associated with the name in column B, that is a look up from sheet 2

Sheet 2 has the names and values, however in a different order, such as:
Alex 16
Colin 15
Denzil 4
Bill 10

I am a bit lost.
Thanks

 

[rskip]

I guess the question is how to do 2 lookups in the same statement

 

[Fluff]

You can do that like

=INDEX(Sheet2!$B$2:$B$10,MATCH(A2,Sheet2!$A$2:$A$10,0))

 

[rskip]

Thank You

 

[Fluff]

You're welcome & thanks for the feedback.