Maybe this

[Ken]

=LARGE(--($B$2:$B$100="smith")*--($D$2:$D$100="yes")*$C$2:$C$100,1)
CSE

 

[Aladin Akyurek]

Ken,

No idea whose problem this meant to solve. But it's superfluous to introduce
the -- coercer when * is already used to multiply the arrays resulting from
conditionals like ($D$2:$D$100="yes").

Aladin