Hi all,

Help please !!

I have been using this formula to do lookup and return values
"=INDEX(ResultsColumn,SMALL(INDEX((CriteriaColumn=Criteria)*(ROW(CriteriaColumn)-ROW(FirstCellOfCriteriaColumn)+1),),COUNTIF(CriteriaColumn,"<>"&Criteria)+ROWS(A$1:A1)))"

I have come across a little problem and needing a little help on a solution.

i'm using this formula in a roster scene to pick up people that call in sick and display their rostered job in a different cell.
the problem that i am having say for example employee one calls in sick at 2 pm and i assign that job in a corresponding cell to another,
then employee 2 calls in sick for the 1pm shift (the call was made after i have already rostered employee one a replacement), the formula automatically places the 1 pm in the cell above the 2pm.
is there a way to stop it from changing the value once a value is entered in a corresponding cell?

I would like to thank Member "tigeravatar" for providing the formula totarial in the first place below is the link to the original formula thread.
http://www.excelforum.com/tips-and-t...e-results.html