Multiple data validation across multiple fields

[data_entry_dude]

HELP!

I have a spreadsheet setup like a timesheet: Employee Name, Classification, Rate, etc.

I setup the Employee Name field as a drop-down. Since there are numerous employees with different rates, I want to just select a name so that the other fields fill-in with the appropriate rates.

Is this possible??

 

[T. Valko]

HELP!

I have a spreadsheet setup like a timesheet: Employee Name, Classification, Rate, etc.

I setup the Employee Name field as a drop-down. Since there are numerous employees with different rates, I want to just select a name so that the other fields fill-in with the appropriate rates.

Is this possible??

See if this helps:

http://contextures.com/xlFunctions02.html