I'm getting an Incorrect Argument Set and I Can't Find My Error

Dianna G

I have a formula referencing a separate table to assign a record to a person based on spend & category. I've written the formula so that if the reference table is missing a name in a field it will look at the next level up in the table to assign the record to that person. The formula would continue up the chain until it finds a name to assign it to (the top level being the Director Range). My formula is returning with an Incorrect Argument Set but I cannot figure out where the is

=IF([Estimated TOTAL Spend for Contract Term]@row < 250000, IF(ISBLANK(INDEX({Sr Buyer Range}, MATCH(Category@row, {Category Range}, 0))), IF(ISBLANK(INDEX({Sourcing Specialist Range}, MATCH(Category@row, {Category Range}, 0))), IF(ISBLANK(INDEX({Sourcing Sr Specialist Range}, MATCH(Category@row, {Category Range}, 0))), IF(ISBLANK(INDEX({Sourcing Cat Manager Range}, MATCH(Category@row, {Category Range}, 0))), INDEX({Sourcing Director Range}, MATCH(Category@row, {Category Range}, 0))), INDEX({Sourcing Cat Manager Range}, MATCH(Category@row, {Category Range}, 0))), INDEX({Sourcing Sr Specialist Range}, MATCH(Category@row, {Category Range}, 0))), INDEX({Sourcing Specialist Range}, MATCH(Category@row, {Category Range}, 0))), INDEX({Sr Buyer Range}, MATCH(Category@row, {Category Range}, 0)), "")

If there are any suggestions on how I can simplify this formula, I welcome that too. I need to incorporate three more levels of spend criteria and follow the same roll up pattern for the sourcing ranges.

Paul Newcome

How exactly is your reference table set up? It may be easier to potentially add a helper column to the reference sheet which could drastically reduce the complexity of this formula as well.