Hi all

I can't help but think that the following must be possible, but I can't quite work out how to achieve it;

I have a sheet containing employee data (one employee record per row), and a set of columns which contain the management hierarchy for each employee. For instance, the first column in the management hierarchy set contains the employee's manager, the second contains the manager's manager, the third contains the managers' managers' manager, and so on, up to the 9th level.

What I want to do is check the all the cells containing managers names per row, and identify if any of the cell values match a separate list of managers names. If so, then I would like to return the corresponding managers name in one cell at the end of the row.

I guess that I might have to sort or rank my separate managers list, so that if multiple, different matches are found in a row, then it is clear which corresponding value from the managers list should be returned.

Ideally, I'd prefer a formula, as I'm not as strong on VBA, but if a macro is the only answre, then I'm happy to accept this.

Edit: I've just realised that an attached example might have been helpful - I will try to pull an example worksheet together.