Forum Discussion
Solved
Vlookup to return the value at the same lookup value row
Vlookup returns the first value it matches. Is there a way for it to return the value on the same row as the lookup value? Example below LookUp N23 Column AT Row 20 value is 1.61 Column AT Row 2...
In AA23:
=INDEX(AN23:AX23, MATCH(N23, AM23:AW23, 0))
or
=INDEX(AN23:AX23, XMATCH(N23, AM23:AW23))
In AA23:
=INDEX(AN23:AX23, MATCH(N23, AM23:AW23, 0))
or
=INDEX(AN23:AX23, XMATCH(N23, AM23:AW23))
Thank you. It works and much better than doing vlookups.
