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
|