Formula - Creating A Sublist from a master list

[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.

 

[Panda514]

Hello,

I think you are saying that your first sheet (Client List) looks like this:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Client Code[/TD]
[TD]Client Name[/TD]
[TD]AT Member 1[/TD]
[/TR]
[TR]
[TD]TSM[/TD]
[TD]Toyota of Southern Maryland[/TD]
[TD]Jason[/TD]
[/TR]
</tbody>[/TABLE]

And you want your second sheet to look like this:

AT Members Name	Client Name
Jason	Toyota of Southern Maryland

<tbody>
</tbody>

<table class="wysiwyg_dashes" verdana,="" arial,="" tahoma,="" calibri,="" geneva,="" sans-serif;"="" width=""><tbody></tbody></table>If that is the case then you can use an index match to get what you want. My formula assumes Jason is in cell A2 on your second sheet.

=INDEX(Sheet1!B:B,MATCH(A2,Sheet1!C:C,0),0)

This is only a good idea if there are not AT Member's with the same name. It is always best to use a unique ID to identify people.