hi,

you may refer to my article at the following website -
http://office.microsoft.com/en-us/ex...260381033.aspx

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"jackie" wrote in message
...
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!