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
|