Your formula is great, really excellent, I like it.
However, I have tested it in another worksheet that solves another
problem, and it has a peculiar behaviour.
1. No matter what the first argument of the LOOKUP function is, it
always returns the last appearance of the searched value.
2. If I use 3 instead of 2, it also works in the example given to you,
even though the team is made of only 2 people.
I wish I could understand a little more how your formula works.
Thank you very much indeed.