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

Chris McKinnon

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?

Paul Newcome

Thanks for the vote of confidence. Haha.

I am going to suggest a COLLECT function instead of the MATCHes.

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