John,
Your might Also find this useful:
=CALC(INDEX(StaffGrade,MATCH(A2,StaffNo,0)),"Crew" )
' Short & Fast: CALC(Expected, If_Error)
Function Calc(Expected, Optional If_Error)
Calc = Expected
If IsError(Expected) Then Calc = If_Error
End Function
Ola
|