I have the following rows of data in my sheet. Here's 7 as an example, but I essentially have over 1000 rows of data.
[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Account
[/TD]
[TD]Owner
[/TD]
[TD]Segment
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Tesla
[/TD]
[TD]Jess
[/TD]
[TD]COM
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Brookstone
[/TD]
[TD]Kelly
[/TD]
[TD]SMB
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]GoPro
[/TD]
[TD]Jess
[/TD]
[TD]SMB
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]Apple
[/TD]
[TD]Linda
[/TD]
[TD]ENT
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]Google
[/TD]
[TD]Kelly
[/TD]
[TD]ENT
[/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]Netflix
[/TD]
[TD]Jess
[/TD]
[TD]COM
[/TD]
[/TR]
</tbody>[/TABLE]
What I want to do is have a drop down list or a pick list setup so that when I select Jess from the picklist, all of Accounts show up like this...
[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]H
[/TD]
[TD]I
[/TD]
[TD]J
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD="align: right"]Pick Rep:
[/TD]
[TD="align: center"]Jess
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD="align: center"]Account
[/TD]
[TD="align: center"]Segment
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD="align: center"]Tesla
[/TD]
[TD="align: center"]COM
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD="align: center"]GoPro
[/TD]
[TD="align: center"]SMB
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD="align: center"]NetFlix
[/TD]
[TD="align: center"]COM
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
What excel formula do I put in cell H4 (and the rest of the rows in that column downwards) so that every time I change the account owner in cell I1, the appropriate list of accounts show up? If this isn't possible what other options do I have? I figured out the equation for I4 downwards =INDEX(A:A, MATCH(H4, C:C, 0)) but just need cells from H4 down to H1000.
Thanks!
[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Account
[/TD]
[TD]Owner
[/TD]
[TD]Segment
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Tesla
[/TD]
[TD]Jess
[/TD]
[TD]COM
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Brookstone
[/TD]
[TD]Kelly
[/TD]
[TD]SMB
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]GoPro
[/TD]
[TD]Jess
[/TD]
[TD]SMB
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]Apple
[/TD]
[TD]Linda
[/TD]
[TD]ENT
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]Google
[/TD]
[TD]Kelly
[/TD]
[TD]ENT
[/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]Netflix
[/TD]
[TD]Jess
[/TD]
[TD]COM
[/TD]
[/TR]
</tbody>[/TABLE]
What I want to do is have a drop down list or a pick list setup so that when I select Jess from the picklist, all of Accounts show up like this...
[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]H
[/TD]
[TD]I
[/TD]
[TD]J
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD="align: right"]Pick Rep:
[/TD]
[TD="align: center"]Jess
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD="align: center"]Account
[/TD]
[TD="align: center"]Segment
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD="align: center"]Tesla
[/TD]
[TD="align: center"]COM
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD="align: center"]GoPro
[/TD]
[TD="align: center"]SMB
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD="align: center"]NetFlix
[/TD]
[TD="align: center"]COM
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
What excel formula do I put in cell H4 (and the rest of the rows in that column downwards) so that every time I change the account owner in cell I1, the appropriate list of accounts show up? If this isn't possible what other options do I have? I figured out the equation for I4 downwards =INDEX(A:A, MATCH(H4, C:C, 0)) but just need cells from H4 down to H1000.
Thanks!