Hi Paul,

Thanks for your quick help. Your suggestion works just fine. I have been searching around this site, too, and answered another question I had about creating "lists" and drop-down boxes. I spent WEEKS trying to figure that out! This is an incredibly helpful resource.

I do have a second question if you happen to come back:

Here is the situation I am ultimately trying to figure out:

John, Sells Package A, gets 65%

John, Sells Package B, gets 55%

Bill, Sells Package A, gets 65%

Bill, Sells Package B, gets 45%

So you see, I am actually juggling three variables. Salesman / Package / Commission.

I want to be able to choose the salesman from a drop down list ( which I've mangaged to figure out) then select the pacakge (for which I'll create another dropdown list) and finally have the percentage applicable to that salesperson AND the package enter into another column.

Is there ONE example of a formula that you can offer for one salesman that I can then extrapilate to apply to the other variables?

Is there other solution you would recommend to keep this straight. I'm not afraid to learn something just slightly ahead of my "grasp", so if you have a suggestion......