={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)}
