View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

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