I need to type a number in sheet 1, a2.. It will go to sheet 2 and match
that number with all the numbers in column a and copy the name next to that
number back to sheet 1,b2

In Sheet1,
Put this in B2: =INDEX(Sheet2!B:B,MATCH($A2,Sheet2!$A:$A,0))
Copy down
--
Max
Singapore
---