Hi everyone,

Due to the formula pulling from a large database of confidential information I can only post the formula. The two issues I am having is that I can only set one criteria (>=480) when I want a second one looking for an "ADMIT" status in column O. The second issue is that my formula keeps returning one row past the designated criteria. Thanks in advance for the assistance.

=IF(ISERROR(INDEX('01-31-16'!$A$2:$Z$100,SMALL(IF('01-31-16'!$Y$1:$Y$100>=480,ROW('01-31-16'!$Y$1:$Y$100)),ROW(1:1)),12)),"",INDEX('01-31-16'!$A$2:$Z$100,SMALL(IF('01-31-16'!$Y$1:$Y$100>=480,ROW('01-31-16'!$Y$1:$Y$100)),ROW(1:1)),12))