index,match + 1 cell below?

[Guest]

if you are using the index/match combination function is it possible to index
the row below the result. In other words is it possible to take result of
index(a1:a5,match(c1,b1:b5),0)) and add one row.

Thanks most helpful ones
ST

 

[Bob Phillips]

Of course, add 1

=INDEX(A1:A5,MATCH(C1,B1:B5)+1,0)

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Aladin Akyurek]

Since you appear to look up with match-type (range_lookup in MS
parlance) set to 1/TRUE, I'll gamble that you probably want:

=INDEX($B$1:$B$5,MATCH(C1,$A$1:$A$5)+(LOOKUP(C1,$A$1:$A$5)<>C1))

Otherwise, see Bob Phillips's reply.

 

[Guest]

if you are using the index/match combination function is it possible to index
the row below the result. In other words is it possible to take result of
index(a1:a5,match(c1,b1:b5),0)) and add one row.

Thanks most helpful ones
ST

 

[Guest]

BOB / ALADIN, both of replies provided solution.

Thank you both greatly!