Lookup value

Hi there,   I have a table with employee's name and his/her position and need to write formula to get results as it is shown in column 'Position_Full'. Lookupvalue didn't work.. Any help please?  ...