Hi,

I will like to write a formula to return a certain value in excel.
Basically, say if C4 cell contains x,y, or z then I want D4 to find the last cell (in colum C) with x, y or z and return a value equal the corresponding D value +1

Any help at all will be appreciated. I can give more explanation if this isn't clear.

Thanks