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.

Column A Column B
1 Tesla Jess
2 Toyota Kelly
3 GoPro Jess
4 Apple Linda
5 Google Kelly
6 Netflix Jess
7 Oracle Joe

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 on cell F1, all of Accounts show up like this starting on cell E4 and below...

Column E Column F
1 Pick Rep: Jess
4 Tesla
5 GoPro
6 Netflix

What Google Sheets formula do I put in cell E4 (and the rest of the rows in that column downwards) so that every time I change the account owner in cell F1, the appropriate list of accounts show up? If this isn't possible what other options do I have?

1 Answer 1


=filter(A:A,B:B=$F$1) in E4 will give you all the accounts belonging to whichever owner you select in F1.

  • I just did this but I get the following error ("FILTER has mismatched range sizes. Expected row count: 8373. column count: 1. Actual row count: 1, column count: 1.")
    – tph510
    Commented Mar 20, 2023 at 17:42
  • nm! It worked (fat finger on my part). This is brilliant and so easy. Thank you!!!
    – tph510
    Commented Mar 20, 2023 at 17:46
  • Glad to help. Please mark the answer as accepted if it meets your requirements. Commented Mar 20, 2023 at 19:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.