Extract Values From One Column Based on Criteria From Another Column

Good morning,

I am looking for a formula that will look at the values in one column of a sheet, and if those values are less than a reference cell, return the item identifier from another column, into sheet 2. In the attached on sheet 2, I need to pull the item identifier from column B in sheet 1, where the values in column F of sheet 1 are less that cell N2 of sheet 1. Perhaps I need more coffee but I've been playing with if, index, and lookup statements but can't seem to get it to work. Thanks in advance!

In cell A2 on sheet 2 put the following formula:

=IF(ROW(A1)>COUNTIF(Sheet1!$F:$F,"<" & Sheet1!$N$2),"",INDEX(Sheet1!A:A,SMALL(IF(Sheet1!$F$2:$F$15<Sheet1!$N$2,ROW(Sheet1!$F$2:$F$15)),ROW(A1))))

This is an array formula and must be confirmed with Ctrl-Shift-Enter, not just enter.

Once it's entered drag across and down.

Nice done, Andrew and benishiryo! I appreciate the help! Cheers!