I am trying to use the lookup formula. This is the formula I use:
Naturally I would have to copy this down the column. The problem I am having is that when I copy it down the column, the references also change.
=LOOKUP(D5,Roster!C4:C185,Roster!D4:D185)<br /> =LOOKUP(D6,Roster!C5:C186,Roster!D5:D186)<br /> etc
What I want to happen though is to have the Dcolumn change without changing the reference for the Roster. Can somebody help me?