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 2...
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.
