Need help with formula

Occasional Visitor

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.

 

gberrocal_0-1637007267120.png

gberrocal_1-1637007300944.png

 

 

2 Replies

@gberrocal 

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

@gberrocal 

As variant

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

however, better to avoid using of entire colums