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)

Chris McKinnon

@Paul Newcome - you always seem to have the answers! any help?

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)

Chris McKinnon

@Paul Newcome - that worked perfectly. ty

Paul Newcome

Happy to help. 👍️