zjamespryor
New Member
- Joined
- Aug 7, 2014
- Messages
- 12
- Office Version
- 365
- Platform
- Windows
Hello Spreadsheet Experts,
I am building this in Google Sheets. I am having trouble coming up with a formula to filter through some data and join the results together in a single cell. In the spreadsheet below, the data being collected by a Google Form is on the right. On the left I've put my desired results for how I'd like to filter out the data on another sheet. I've included a small table below that as a place to figure out the correct formula. Thank you in advance for any help you can offer.
I am building this in Google Sheets. I am having trouble coming up with a formula to filter through some data and join the results together in a single cell. In the spreadsheet below, the data being collected by a Google Form is on the right. On the left I've put my desired results for how I'd like to filter out the data on another sheet. I've included a small table below that as a place to figure out the correct formula. Thank you in advance for any help you can offer.
Book1 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | |||
1 | Group Selection: | Group 1 | |||||||||||
2 | Campus | Gold Partner | Silver Partner | Bronze Partner | Name | California | Florida | New York | North Carolina | Virginia | |||
3 | California | James | Nancy | James | Gold | Bronze | Silver | ||||||
4 | Florida | Chris, Susan | Nancy | Chris | Gold | Silver | Bronze | ||||||
5 | New York | Chris | James | Susan | Gold | Bronze | Silver | ||||||
6 | Nancy | Silver | Bronze | Gold | |||||||||
7 | |||||||||||||
8 | |||||||||||||
9 | Campus | Gold Partner | Silver Partner | Bronze Partner | Group 1 | Group 2 | |||||||
10 | California | North Carolina | |||||||||||
11 | Florida | Virginia | |||||||||||
12 | New York | ||||||||||||
13 | |||||||||||||
14 | |||||||||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A3:A5 | A3 | =IFERROR(INDEX(F10:G12,,MATCH(B1,F9:G9,0)),"") |
Dynamic array formulas. |
Cells with Data Validation | ||
---|---|---|
Cell | Allow | Criteria |
B1 | List | =$F$9:$G$9 |