Lookup other Row value from sort

[BenH]

Hey everyone!

I was wondering if someone could help with this particular issue.

I have a email template with the following formula, which gives me the Max value of the column [site outage].

<<INDEX(SORT(Canada Alerts[site outage], TRUE), 1)>>

This is great. but I am looking for the value of another column in that exact row. which is [site]. It is probably simple but i cant think of a formula?

Thanks!