Forum Discussion
Solved
Force Excel to search from bottom up (not top down)
Hello Experts, I have attached a file. I am using a "hyperlink" to search by amount. If I click on the hyperlinked cell it takes me to the amount However, it searches top down and I want it ...
Do you have Microsoft 365 or Office 2021? If so, use
=IFERROR(HYPERLINK("#"&CELL("address",INDEX(tblPC[[#All],[Invoice amount]],XMATCH(E3*-1,tblPC[[#All],[Invoice amount]],0,-1))),"Take me there"),"Not Found")
Do you have Microsoft 365 or Office 2021? If so, use
=IFERROR(HYPERLINK("#"&CELL("address",INDEX(tblPC[[#All],[Invoice amount]],XMATCH(E3*-1,tblPC[[#All],[Invoice amount]],0,-1))),"Take me there"),"Not Found")
Wow. that worked perfectly. I didnt know that about XMATCH. Nice. thank you!