Hi,

In Sheet2 where you want the name:

=OFFSET(Sheet1!$B$1,MATCH(B2,Sheet1!$B$2:$B$10,0),-1)

HTH

Steve