Doesn’t change my answer, but if it helps, create a template column in the related sheets that joins whatever value you are using for the relation, with the column value that you have in your existing lookup. Use that template as your lookup against the first relation. Then use that lookup to create your second relation.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| How to search & compare 2 (or more) rows with data in different tables | 27 | 1626 | January 17, 2024 | |
| Write an array column (via Lookup) to Google sheet | 42 | 4425 | August 13, 2020 | |
| 🚀 Set Column Action: Alter a DIFFERENT SHEET'S VALUES! | 88 | 6924 | September 10, 2021 | |
| Stop watching TV and play with the enhanced If/then/else | 30 | 1437 | May 26, 2020 | |
| Is there a way to filter duplicates from an inline list? | 40 | 3970 | January 17, 2024 |