I am not sure which formula is best: Index, Lookup etc.

None.

Pivot table is the best option


"jackie" wrote:

Hi All- I need help returning a list of names on a separate sheet. I'll
enter "manager 1" in an input cell, and i want to return a list of
corresponding sales reps until i run out.

I am not sure which formula is best: Index, Lookup etc.


A B
manager 1 sales rep 1
manager 1 sales rep 2
manager 1 sales rep 3
manager 2 sales rep 4
manager 2 sales rep 5

thanks!