J
Jenni
I have created a spread sheet that lists all of our field
employees in one column with their wages in the next
column. On a seperate worksheet I have created a layout
for scheduling man hours. The goal is to keep the labor
rate of the job at or below the estimated labor rate. I
am using data validation to ensure that the user can only
pick valid employee names. None of that is a problem. The
problem is: once they have selected an employee name, I
would like the cell beside the name to show that
employees wage. I tried writing an IF-THEN statement, but
since I have over 100 employees on the list, the
statement is too long. Is there a better way to do this?
employees in one column with their wages in the next
column. On a seperate worksheet I have created a layout
for scheduling man hours. The goal is to keep the labor
rate of the job at or below the estimated labor rate. I
am using data validation to ensure that the user can only
pick valid employee names. None of that is a problem. The
problem is: once they have selected an employee name, I
would like the cell beside the name to show that
employees wage. I tried writing an IF-THEN statement, but
since I have over 100 employees on the list, the
statement is too long. Is there a better way to do this?