return value on match of list?

[BeerBeer101]

I've tried a number of options, but can's seem to get there - but I know this team will find it! (and sorry, cannot install xl2bb)
Sheet 1 - has list of last names, Group and Year

Sheet 2 - has list of last names - some match, some don't. i want the grp and level to move to sheet 2 and return false (or user defined) when a name is not on sheet 1.

thanks!

 

[MARZIOTULLIO]

Sheet2
B2=IF(AND(Sheet2!$A2<>"",Sheet2!B$1<>""),IFERROR(INDEX(Sheet1!$B$2:$C$100,MATCH(Sheet2!$A2,Sheet1!$A$2:$A$100,0),MATCH(Sheet2!B$1,Sheet1!$B$1:$Z$1,0)),"no match"),"")

Copy across and down