Pulling Wage data from one chart to another chart for scheduling

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Jenni (anonymous_at_discussions.microsoft.com)
Date: 07/16/04 

Date: Fri, 16 Jul 2004 05:19:04 -0700

I have created a spread *** that lists all of our field
employees in one column with their wages in the next
column. On a seperate work*** 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?

Quantcast