Forum Discussion
gberrocal
Nov 15, 2021Copper Contributor
Need help with formula
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 Replies
- SergeiBaklanDiamond Contributor
As variant
=INDEX( M:M, XMATCH(A2#, I:I) )however, better to avoid using of entire colums
=VLOOKUP(A2,$I:$M,5,FALSE)