Creating a sublist from a master list in a separate sheet

[zjohnson]

I have a master list of clients in a sheet (Client List)- the list is broken down into 3 columns - client code, client name, AT Member 1.

On a separate sheet, I am trying to create a formula that will auto-populate under the correct AT Members name.
ex: Client List! TSM Toyota of Southern Maryland Jason
and in the other sheet I have a section for Jason that I would want Toyota of Southern Maryland to auto-populate under.

[Richard Buttrey]

A Pivot Table, perhaps with Slicer or two to filter it easily would be your best option.