Copy VLOOKUP Formular without table array ref changing

Hi All

I have managed to write the following formular

=VLOOKUP((C10),'Roster Codes'!A4:B22,2,FALSE)

what i need to do now is copy it across a months worth of roster, but when trying to click and drag it changes the C10 ref as expected (and wanted) to the next corresponding Cell, but it also changes the Table Ref?!?

Is there a way to lock the table ref, it seems silly that a formular that reads from a fixed data table would assume that the table moves from its original position.

I have 22 staff and need this formular on every day on the year for all staff. the purpose is to calculate hours.
For example: C10 shows D, then the lookup would search table and give result 12
LV=8
D=12
N=12

i was using a long IF formular but i now have over 7 different data possiblities

any help appreciated

Hi,
have a look at absolute references
Your formula should be =VLOOKUP(C10,'Roster Codes'!$A$4:$B$22,2,FALSE)