which-formula-can-be-used-to-find-designation-of-a

Which formula can be used to find designation of an employee with the help of Employee name in the given range in the image below