Spreadsheet: 842516d1694576560-would-like-to-list-several-cells-from-a-lookup-incl-other-data-vstack-hstack-mosom-6
Sheet: Sheet1

 |  |  |  |  | Role 1 | Role 2 | Role 3 | Role 4 | Role 5 |  | CURRENT SETUP |  |  |  |  |  |  |  | WHAT I WOULD LIKE |  |  |  |  |  |  |  |  |  |  |  |  |  | Manager: | Manager 3 | <- drop down list |  | Manager: | Manager 1 | Manager 2 | Manager 3
Topic 1 | Module 1 | Area 1 | Focus 1 |  | Yes | Yes | Yes | Yes | No |  | choose a role from drop down below, it lists the full row according to yes/no |  |  |  |  |  |  |  | to be able to list the Summary Text field (with its leading columns) above the lists, by managerial role: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Role 1 | y | y
Topic 1 | Module 1 | Area 1 |  |  | No | Yes | Yes | No | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Roles: |  |  |  | Role 2 | y |  | y
Topic 1 | Module 1 | Area 1 |  |  | No | Yes | No | No | Yes |  | Role: | Role 1 | <- drop down list of the different roles (Role 1, Role 2 etc) |  |  |  |  |  | Manager: | Manager 2 | <- drop down list of the different roles (Role 1, Role 2 etc) |  |  |  |  |  |  |  |  |  |  |  |  | Role 3 |  |  | Role 3 | y | y | y
Topic 1 | Module 1 | Area 2 | Focus 1 |  | Yes | Yes | No | No | Yes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Role 5 |  |  | Role 4 | y | y
Topic 1 | Module 1 | Area 2 | Focus 2 |  | No | N/A | Yes | Yes | No |  |  |  |  |  |  |  |  |  | Roles: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Role 5 | y |  | y
Topic 1 | Module 1 | Summary |  |  | text field 1 | text field 2 | text field 3 | text field 4 | text field 5 |  |  |  |  |  | Module 1 | Summary | text field 1 |  |  | Role 3
Topic 1 | Module 2 | Area 1 | Focus 1 |  | Yes | No | No | Yes | Yes |  |  |  |  | Topic 1 | Module 2 | Summary | text field 6 |  |  | Role 4
Topic 1 | Module 2 | Area 1 | Focus 2 |  | N/A | No | Yes | Yes | Yes
Topic 1 | Module 2 | Area 2 | Focus 1 |  | N/A | Yes | Yes | Yes | No |  |  |  |  | Topic 1 | Module 1 | Area 1 | Focus 1 | y
Topic 1 | Module 2 | Area 3 | Focus 1 |  | No | Yes | Yes | Yes | No |  |  |  |  | Topic 1 | Module 1 | Area 2 | Focus 1 | y
Topic 1 | Module 2 | Area 3 | Focus 2 |  | Yes | N/A | Yes | No | Yes |  |  |  |  | Topic 1 | Module 2 | Area 1 | Focus 1 | y |  | eg if Manager 2 is selected above, this then includes Roles 1, 3, ,4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Module 1 | Area 1 | Focus 1 | y |  | Module 1 | Area 1 | Focus 1 |  | Module 1 | Area 1 | Focus 1
Topic 1 | Module 2 | Summary |  |  | text field 6 | text field 7 | text field 8 |  | text field 10 |  |  |  |  | Topic 1 | Module 2 | Area 3 | Focus 2 | y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 2 | Focus 1 | y | Topic 1 | Module 1 | Area 1 |  | Topic 1 | Module 1 | Area 2 | Focus 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 1 | Focus 1 | y | Topic 1 | Module 1 | Area 2 | Focus 2 | Topic 1 | Module 2 | Area 1 | Focus 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 1 |  | n |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 3 | Focus 2 | y | Topic 1 | Module 2 | Area 1 | Focus 2 | Topic 1 | Module 2 | Area 3 | Focus 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 1 |  | n |  | Topic 1 | Module 1 | Summary | text field 1 | these are the summaries for Role 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 2 | Focus 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 2 | Focus 2 | n |  | Topic 1 | Module 2 | Summary | text field 6 |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 1 |  | n | Topic 1 | Module 2 | Area 3 | Focus 1 | Topic 1 | Module 1 | Area 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 3 | Focus 1 | n |  | Topic 1 | Module 1 | Summary | text field 3 | these are the summaries for Role 3 |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 1 |  | n | Topic 1 | Module 2 | Area 3 | Focus 2 | Topic 1 | Module 1 | Area 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Summary | text field 8 |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 2 | Focus 2 | n |  |  |  |  | Topic 1 | Module 1 | Area 2 | Focus 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Summary | text field 4 | these are the summaries for Role 4 |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 3 | Focus 1 | n | Topic 1 | Module 1 | Area 1 |  | Topic 1 | Module 2 | Area 3 | Focus 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 2 | Focus 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 1 | Focus 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 1 | Focus 1 |  |  |  | Module 1 | Summary | text field 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 1 | Focus 2 |  |  | Topic 1 | Module 2 | Summary | text field 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 1 | Focus 3 |  |  | Topic 1 | Module 1 | Summary | text field 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 2 | Focus 1 |  |  | Topic 1 | Module 2 | Summary | text field 8 |  |  |  |  |  |  |  |  |  |  |  | Module 1 | Area 1 | Focus 1 | y
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 2 | Focus 1 |  |  | Topic 1 | Module 1 | Summary | text field 4 |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 2 | Focus 1 | y
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 3 | Focus 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 1 | Focus 1 | y
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 3 | Focus 2 | y
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 1 | Focus 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 1 | Focus 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 1 |  | n
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 1 |  | n
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 2 | Focus 2 | n
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 3 | Focus 1 | n
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 1 | Focus 1 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 1 |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 2 | Focus 2 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 1 | Focus 2 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 2 | Focus 1 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 3 | Focus 1 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 3 | Focus 2 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 1 |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 2 | Focus 1 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 1 | Focus 1 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 1 | Focus 1 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 2 | Focus 1 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 1 | Focus 1 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 3 | Focus 2 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 1 |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 1 |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 1 | Area 2 | Focus 2 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Topic 1 | Module 2 | Area 3 | Focus 1 | #N/A