Grab lines of data from sheet based on multiple criteria (working slightly)

Originally Posted by JohnTopley

Try


=SMALL(IF(([Test_book.xlsx]Sheet1!$E$3:$E$341="Pre-Approvals")+([Test_book.xlsx]Sheet1!$E$3:$E$341="In-Approvals"),ROW([Test_book.xlsx]Sheet1!$E$3:$E$341)),ROW(1:1))-2

This worked perfectly! Thank you so much! I've rep'd you