I have a spreadsheet that calculates employees time. I input the employees
code in column C fields and hours in column D fields and it gives me there
pay totals. When I input a the employees code the rate that conincides with
that code automatically pops up in column F. I can change the amount of the
rate that comes up by going to another sheet in that workbook titled
"Parameters" and changing the dollar amounts on htat sheet. However if I try
to add a new code and payrate to the sheet it does not recognize it on the
Time Entry sheet. It comes up #N/A. There is also something that is unusual
with the parameters page. The codes that are already on the sheet are
aligned on the left side of the cell but there is no left justification for
it, and if I click on to a code and change the number, it jumps to the right
of the cell and then comes up #N/A. How can I add new rates?

Thanks for any help you are able to give.

By the way, the formula in the rate field on the Time Entry sheet is
=IF(C7="",0,VLOOKUP(C7,INDIRECT("EmployeeList"),2, FALSE))