CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
Gaaaaaab
Gaaaaaab

Reputation: 135

Returning Data Base on Dropdown Value

I'm trying to create a sheet where it will automatically fill out columns based on their role.

I have here Sheet 1, the dump where players' name will be placed and a dropdown of their roles.

Roles

On another sheet (Sheet 2), I have 2 columns, of which I need to sort if they are a player (Rank 1 to Rank 5) or a setter.

Sheet 2

I am trying to return the values of 'Name' to its respective column on Sheet 2. I tried using arrayformula with ifs but it just returns false. Is there a way for me to do this?

Here's a sample file: https://docs.google.com/spreadsheets/d/1Qkk9a3r3xJbRgqJfKQKGN8vSrAUz259D5ICuf4bAAaU/edit#gid=1063674487

Upvotes: 0

Views: 71

Answers (1)

TheMaster
TheMaster

Reputation: 50462

Filter by Rank or Setter:

=FILTER(Sheet1!A2:A10, Sheet1!B2:B10="Setter")

For rank, try <>Setter

Upvotes: 1

Related Questions