Okay, I created a formula using Indirect, Vlookup, and Match that accesses multiple tables listing named ranges. Originally the formula worked perfectly, and actually still does, however, I have to incorporate an additional component of the comp plan into this formula... that is where I am having problems. The working formula resides in all rows, and the formula I am attempting to revise resides only in row 19.

Original (Working) formula:
=IFERROR(IF($I18="","-",IF($J18="Not Qualified","No Bonus",IF(AA18<1350,IF($I18<INDIRECT(VLOOKUP($E18,info_CP2,3,FALSE)),"No Bonus",INDEX(INDIRECT(VLOOKUP($E18,info_CP2,6,FALSE)),MATCH($I18,INDIRECT(VLOOKUP($E18,info_CP2,5,FALSE)),1),1)),IF($I18<INDIRECT(VLOOKUP($E18,info_CP,3,FALSE)),"No Bonus",INDEX(INDIRECT(VLOOKUP($E18,info_CP,6,FALSE)),MATCH($I18,INDIRECT(VLOOKUP($E18,info_CP,5,FALSE)),1),1))))),"-")

Attempt at revised formula:
=IFERROR(IF($I19="",0,IF($J19="Not Qualified","No Bonus",IF(AA19<1350,IF($I19<INDIRECT(VLOOKUP($E19,info_CP2,3,FALSE)),"No Bonus",INDEX(INDIRECT(VLOOKUP($E19,info_CP2,6,FALSE)),MATCH($I19,INDIRECT(VLOOKUP($E19,info_CP2,5,FALSE)),1),1)),IF($I19<INDIRECT(VLOOKUP($E19,info_CP,3,FALSE)),"No Bonus",INDEX(INDIRECT(VLOOKUP($E19,info_CP,6,FALSE)),MATCH($I19,INDIRECT(VLOOKUP($E19,info_CP,5,FALSE)),1),1))))),IF($B19=$AL$1,IF(AA19<1350,IF($I19<INDIRECT(VLOOKUP($B19,info_CP2,3,FALSE)),"No Bonus",INDEX(INDIRECT(VLOOKUP($E19,info_CP2,6,FALSE)),MATCH($I19,INDIRECT(VLOOKUP($E19,info_CP2,5,FALSE)),1),1)),IF($I19<INDIRECT(VLOOKUP($E19,info_CP,3,FALSE)),"No Bonus",INDEX(INDIRECT(VLOOKUP($E19,info_CP,6,FALSE)),MATCH($I19,INDIRECT(VLOOKUP($E19,info_CP,5,FALSE)),1),1))),0))

Factors for revision, if the employee #, listed in cell B19, matches the current team lead employee # listed in cell AA19, then the alternate component plan is to be used. Both the regular employee and the lead have a contingency that if the the VPG they achieve is less than $1350, the maximum bonus level they can qualify for is level 3 (of 5 levels). This contingency resides in table info_CP2 table. The table for regular staff is called info_CP and the table for the lead is called info_CP3. The reason there are tables with named ranges, as many of the staff are at a pro-rated percentage, and thus have different requirements as a result, and different payouts too.

Any help is appreciated!