I am setting up a buget plan that has 25 different formulas depending on the Sales persons split plans. What I would like to setup is a table or something that lists the 25 different formulas possible for 250 different agents.

The formulas look like this:
=IF(Q40<65000,Q40*60%,39000)+IF(Q40>85000,14000,IF (Q40>65000,(Q40-65000)*70%,0))+IF(Q40>100000,11250,IF(Q40>85000,(Q 40-85000)*75%,0))+IF(Q40>100000,(Q40-100000)*90%,0)

and there is 25 different levels.

In one column we enter the Plan ID# and the Q40 would be the agents expected sales income.

What direction should I be heading in? Vlookup? And if somoene could post an example I would be estatic.

Thanks,

Wayland3r