I should also point out that the employee names should be unique.

Tyro

"Tyro" wrote in message
. net...
Use a vlookup. If the employee names are in A1:A100 and pay rate in
D1:D100 and the employee name you're looking up is in E1 then
=VLOOKUP(E1,A1:D100,4,FALSE)
The employee name in E1 has to exactly match the name in A1:A100. The
names do not have to be in sequence.

Tyro

"Meadowlark" wrote in message
...
I am tired of looking up and typing in each employees pay scale. Their
names
are always in A and rate of pay in D. How can I solve this.
Thank you