Need help with formula

[gberrocal]

Hello I am trying to find a way to loop through a column and return the row number. Below I am taking A2 and trying to see if it matches anything in column I. If it does return that exact row number so I can take the value from column M with the same row number. Example column I13 matches so it returns 13 and I can take the value from M13.

[#2]

@gberrocal 

=VLOOKUP(A2,$I:$M,5,FALSE)

[#3]

@gberrocal 

As variant

=INDEX( M:M, XMATCH(A2#, I:I) )

however, better to avoid using of entire colums