Index, Match, Small with multiple criteria

Hi everyone,
I need help with finding a combined function to list all the names that fit the criterias below:

Data:

Column A Column B Column C
Name Level Days
A P 1313
B H 144
C M 60
D P 773
E P 90
F P 60


Need to find all the names in Column A that fit both criterias: Level in column B is "P" and Days in Column C is larger than 145.

This is an Excel forum. Instead of posting a pdf... can you post an Excel file? thanks!

Here are two different ways you can do it.

1.) Use a "helper" column in column D with this formula

Formula:

=IF(AND(B2="P",C2>145),ROWS($2:2))

Then enter this formula in A13, fill down and across until you get blanks.

Formula:

=IFERROR(INDEX(A$2:A$7,SMALL($D$2:$D$7,ROWS($13:13))),"")

2.) Or if you prefer to not use a helper column array enter this formula, fill down and across until you get blanks. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

Formula:

=IFERROR(INDEX(A$2:A$7,SMALL(IF(($B$2:$B$7="P")*($C$2:$C$7>145),ROW($A$2:$A$7)-ROW($A$2)+1),ROWS($13:13))),"")