Finding 2nd Largest Item in a List that meets more than 1 Criteria [Excel Array Formulas]

={LARGE(IF(Sheet2!$D:$D=Sheet1!$B$3,IF(Sheet2!$K:$K="",Sheet2!$H:$H,""),""),2)}

You add the brackets by pressing CTRL+SHIFT+ENTER.

Let me explain: Your are looking for the 2nd Largest number with the criteria of having column D = Range(B3) and where Column K = nothing. If you only wanted 1 criteria you would use:

={LARGE(IF(Sheet2!$D:$D=Sheet1!$B$3,Sheet2!$H:$H,""),2)}