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...
anujkhator That could be:
=FILTER(Table1, ISNUMBER(XMATCH(Table1[TenderID], FILTER(Table2[TenderID], XLOOKUP(B1, Table2[#Headers], Table2) = "Yes"))))
See attached, if needed...