Have index match formula search index from bottom to top

[reasem]

Hello all, looking to edit my index match function to pull data from my index from the bottom to top. A lookup formula works too, I searched the forum and tried the formula that people have been posting, this was my function:

=IFERROR(IF(LOOKUP(2,1/('Data Dump'!$Q$2:$Q$20000=U19581),'Data Dump'!$K$2:$K$20000)>"1",LOOKUP(2,1/('Data Dump'!$Q$2:$Q$20000=U19581),'Data Dump'!$K$2:$K$20000),""),"")

However, it wasn't seeming to work for me.
Here's my current function that works but pulls from top down:

=IFERROR(IF(VLOOKUP(CONCATENATE("XXXXX",RIGHT(U19585,4)),PageLength,5,FALSE)>"1",INDEX('Data Dump'!K:U,MATCH(CONCATENATE("XXXXX",RIGHT(U19585,4)),'Data Dump'!Q:Q,0),1),""),"")

 

[DRSteele]

If you have the Excel 365 Insider version you can use function XLOOKUP, one of whose arguments is [search_mode], which enables you search from the bottom up.