=VLOOKUP(A6,[1]Sheet1!$A:$B,2,0)

You may also like