Excel assignment lookup

Can anyone tell how to these two question for excel lookup assignment