View Single Post
  #1   Report Post  
StevenL
 
Posts: n/a
Default 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