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.
