I am using maxifs to return a value based on multiple criteria. Now I need to get the value from the cell in the column next to the max value returned. I have seen other posts on here regarding this but am unable to adapt it to my needs. The formula I am currently using is
=MAXIFS(in_section!$H$2:$H$5000,in_section!$D$2:$D$5000,"="&$B3,in_section!$T$2:$T$5000,"<3.1")

Any help is greatly appreciated.