Index MATCH vs COLLECT (matching 2 values, returning a different value)

Options

Hello all,

I need to look up 2 values on a separate sheet and return a value from another column. I keep getting the "#INCORRECT ARGUMENT SET"

Basically I want to get a % complete back based on 2 value matches (brand) and (task name). The task name is duplicated across brands, but the brand never has the task name twice.


here is the formula I am using-

=INDEX({Migration Task Plan Range task%complete}, MATCH(1, {Migration Task Plan Range brand}, BRAND@row, MATCH({Migration Task Plan Range brand}, {Migration Task Plan taskname}, "Sitemap & Navigation Finalization")))


Any insight?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!