Looking Up the Next Value after I locate the correct row of the value i need

Question

enter image description hereIf i have the unique number, how can i get the next value from column M? Say, my unique number is 10, then the value that i need is the value from 13. I attached the picture to illustrate.

I tried doing Offset function but doesn't work. Please help.

In the second screenshot, I used this:

=let(Σ,xmatch(K2,K:K)+1,+tocol(indirect("M"&Σ&":M"),1))

By the way, I am using Google Sheets

Answer 1

Use INDEX-XMATCH with dynamic offset:

=LET(n,10,k,K2:K,m,M2:M,
     INDEX(m,XMATCH(n,k)+
       MMULT(
         TOROW(QUERY(FILTER(ROW(m),n<=k,""<>m),"limit 2")),
         {-1;1})))

Answer 2

You may try:

=let(Σ,xmatch(10,K:K)+1,
     +tocol(indirect("M"&Σ&":M"),1))