Returning the last value from the FILTER function in google sheets

Question

I'm using Google Sheets and would like to get the last value in column when it is filtered based on the values in a separate column as shown in the screenshot:

I'd like to get the last value from column A, where the value in column B matches that specified in cell D1.

I've managed to do this with the following:

=INDEX(FILTER($A:$A,$B,$B=$D$1),COUNTA(FILTER($A:$A,$B:$B-$D$1)),1)

This works but it seems unnecessary to have the second FILTER and COUNTA as it makes it harder to understand. Is there no way I can just return the last value from the FILTER function?

Since posting this I've found another way that's more concise, but I have to confess I don't actually understand how it works:

=ArrayFormula(LOOKUP(2,1/($B:$B=$D$1),$A:$A))

Answer 1

I know this is a way that I do that sometimes. it takes advantage of the VLOOKUP(....TRUE) [default] option.

=VLOOKUP(9^99,FILTER({ROW(A:A),A:A},B:B=D1),2)