Lets say you have a typical Microsoft excel sheet and on the bottom you have
standard table. You have 5 rows vertically on the left of job codes, like
(1-engineering) (2-coordinating) (3-support) (etc). And five columns
horizontal on top of building floors, like (1st floor) (2nd floor) (3rd
floor) (etc). And above that whole table you have a simple time sheet layout
consisting of 4 cells running horizontal as follows Date , floor level , job
code, and hours , I want to see if it is possible to input the information
on the time sheet like (2) for floor level and (3) for job code and it will
know what cell to reference on the table below with the hours..

ive been trying to figure this out for some time ,
please help