I have this table below. In another tab on the same worksheet, I want to extract all the values from "name" column, that match "status" as NotFound. My formula looks like this:
=INDEX('nameoftab'!A:A, MATCH("NotFound", 'nameoftab'!C:C, 0))
However the formula is only spitting the first value it finds which is Laura. How can I make it so I extract the remaining values in a simple list? I have looked everywhere and not a simple solution found, help please!