index,match + 1 cell below?
 

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

Of course, add 1

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

--

HTH

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


"StevenL" wrote in message
...
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

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.

StevenL wrote:
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

"StevenL" wrote:

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 / ALADIN, both of replies provided solution.

Thank you both greatly!

"StevenL" wrote:

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