=IFERROR(MAX(IF(Ground3!$Y$2:$Y$10=B3,INDEX(Ground3!$A$2:$AQ$10,,MATCH($S$1,Ground3!$A$1:$AQ$1,0)))),"")

or, if you know it is always column T

=IFERROR(MAX(IF(Ground3!$Y$2:$Y$10=B2,Ground3!$T$2:$T$10)),"")