Multiple "IF" commands with different formulas calling from a Table.

Need some help with this one..

I need the Agent portion to update with the Plan ID and use the formula that corresponds to the Plan. This is only a partial list of the PLans. (I have 23) I want to managers to put in the PLAN ID and it looks up the proper formula and uses the Gross REV number to give the portion that is paid to the sales person..

I hope I am explaining this properly. I have attached the file in 2007 and 97-2003 versions...

If there is an easier way to do this please do tell.

Help.xls

Help.xlsx


Thanks,

Waylander