Get cell value but skip row if wrong

Question

I have two tables:

I want to get all names from Table 1 that have status "Denied". I tried using IF formula but it returns blank/other false value. Expected result is Table 3.

Is there any other formula that can solve this?

Answer 1

Use this formula in Table 3 Column 1
=IFERROR(SMALL(IF(($B$2:$B$15="Denied"),$A$2:$A$15,""),ROW()-2),"")

Note: Press CTRL+SHIFT+ENTER after putting in the formula (As it is an array formula) No need for a second table

Use this formula in Table 3 Column 2
=IFERROR(INDEX($B$3:$B$11,MATCH(E3,$A$3:$A$11,0)),"")

Use this formula in Table 3 Column 3
=IFERROR(INDEX($C$3:$C$11,MATCH(E3,$A$3:$A$11,0)),"")