Hi Forum members,
Column A contains numerical unique employee IDs. In the subsequent rows, there are listing of employees with each column representing distinct employee information. In Column K of each row is the employee's Manager ID. Since this is an all-employee file, employees who are Managers will have the same employee ID in Column A as well. Conversely, employees who are NOT Managers, will only have their employee ID appear in Column A, but never in Column K.
I like to built a formula at the last blank column of the file (Column Z) to indicate if an employee is also a Manager (a Yes/No indicator would be fine). For example, Employee #1 (in Row 1) is also a Manager and his Manager ID is listed in Column K with his 2 employees in Row 15 and 16. So, for Employee #1, I like the formula in Row 1, Column Z to show "Yes". But, for Employee #2 (in Row 2) who is NOT a Manager, I like the formula in Column Z to show "No". I tried using a Lookup formula in Column Z but was not successfully. I feel like I need an IF formula, but I am not sure how to write it up.
I would appreciate your help.
Thanks,
Jerry
Bookmarks