Jun 12 2024 04:47 AM
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 23 value is 1.08
How do I return the value of 1.08 which is in Row 23?
Jun 12 2024 04:56 AM
SolutionIn AA23:
=INDEX(AN23:AX23, MATCH(N23, AM23:AW23, 0))
or
=INDEX(AN23:AX23, XMATCH(N23, AM23:AW23))
Jun 12 2024 05:25 AM
In AA23 =VLOOKUP (AA23, INDIRECT ("AS" & ROW(AA23) & ": AT"), 2, 0)
Jun 12 2024 10:41 PM
Thank you. It works and much better than doing vlookups.
Jun 12 2024 10:42 PM
Jun 12 2024 04:56 AM
SolutionIn AA23:
=INDEX(AN23:AX23, MATCH(N23, AM23:AW23, 0))
or
=INDEX(AN23:AX23, XMATCH(N23, AM23:AW23))