Hi and welcome to the board

Are you using relative or absolute references for the lookup and result vector ?
In the first case, the vectors will change when the formula is dragged down

Try converting to absolute references =LOOKUP(F6,'Switch Boards'!$A$5:$A$31,'Switch Boards'!$C$5:$C$31)