Here's the challenge I've been trying to solve:

I record sales and commissions for three different sales people. Each works at a different commission rate. I want to be able to type the NAME of a sales person in the Sales Rep Column and then have his commission rate automatically enter into the Commission Rate column.

There are other things I'd like to do, too, but if someone can help me with the correct formula and/or procedure to do this, then I think I can get the other formulas to work, too.

Many thanks!