Hi All,

This is what i am trying to do.

Column A - Agents' names
Column B - Team Leaders' names
Column C onwards - Other data.

Now in another what I want is that if I enter the Team leader's name, all
the data for his team is returned. For example I enter John in column A, i
want sales in column B, Average in Column C, Agent's name in column D etc.

The problem is that in the first sheet, the team leader's name may appear
several times.

makes sense?

Thanks in advance for any help.