I am really stocked here ( check the screenshot ). I want to return the project name based on a cell ( Investment decision ) that contains "yes" to the " Liquidity Table " . I used the index and match function but it gives me the value in the exact row. For example if I have 200 rows but only 10 yes, I have to insert 200 rows and makes the problem even worst because I have to look all the 200 rows for the projects.
Is there any way to automatically return the values one after another without any blank row?