Hey all,

I'm trying to create a spreadsheet that references an existing Excel file that contains data in the following format:

Supervisor    Name    Email    Phone #
Bob           Joe     a@b.com  555-555-1234
Bob           Joy     b@c.com  555-555-2345
Bob           John    c@d.com  555-555-3456
Colin         Ricky   d@e.com  555-555-4567
Colin         Roy     e@f.com 555-555-5678
Jerry         Alex    f@g.com  555-555-6789

Basically, what I want to do with this information is pull only, say, Colin's employees names and phone #'s, and not display anyone elses. So basically, I'd want it to look like this:

Colin's Employees
Name        Phone            Email
Ricky       555-555-4567     d@e.com
Roy         555-555-5678     e@f.com

I'm almost certain that the VLOOKUP command is what I want to use, but I'm unsure how to apply it to work in my case. I've tried a few different techniques such as...

=VLOOKUP("Colin",'[Existing Sheet.xls]Book1'!$A$2:$D$100,2,FALSE)

However this will display something like:

Colin's Employees
Name
Ricky
Ricky
Ricky
Ricky
Ricky

But will not show the other employees under Colin (In this case, Roy)..

If anyone has any idea, please save me from certain failure!

Thanks.

-Will