Forum Discussion
Filter a table using value selected in a list and filtering another table using the filtered values
Hi All,
I have the following tables
Table 1
| TenderID | ProjectTitle | Organisation |
| 2024_1 | Title 1 | Organisation1 |
| 2024_2 | Title 2 | Organisation2 |
| 2024_3 | Title 3 | Organisation3 |
| 2024_4 | Title 4 | Organisation4 |
Table 2
| TenderID | Tata | Sail | JSPL |
| 2024_1 | Yes | No | Yes |
| 2024_2 | No | Yes | Yes |
| 2024_3 | Yes | Yes | Yes |
| 2024_4 | Yes | No | Yes |
I want to select one of Tata, Sail, JSPL from a List
1. Basis the value selected, I want all those TenderIDs where value in Tata column is "Yes"
2. The ultimate objective is to filter Table1 to show the values with above TenderIDs where value of option selected from the list is "Yes"
Hello, I have solved your task with FILTER() within FILTER(). There is probably another way.
=FILTER(Table1,ISNUMBER(XMATCH(Table1[TenderID],FILTER(Table2[TenderID],OFFSET(E11,1,XMATCH(J11,Table2[#Headers])-1,4)="Yes"))))Please also see my attached file.
anujkhator That could be:
=FILTER(Table1, ISNUMBER(XMATCH(Table1[TenderID], FILTER(Table2[TenderID], XLOOKUP(B1, Table2[#Headers], Table2) = "Yes"))))See attached, if needed...
