The best way, especially since there may be future changes, would be to use
a vlookup table. Look in the help index for VLOOKUP

--
Don Guillett
SalesAid Software

"DHM" wrote in message
...
I have 6 employees with different pay rate. If I enter a name in a cell I
want the next cell to show the pay rate associated with that person. How
do
I do that