Index/Collect returning #INCORRECT ARGUMENT SET

cghallo_Veolia

Hello, Community!

• I'm trying to bring in the value of the Available? column from the Availability sheet into the same named column on the Schedule sheet where: (1) Rescheduled on Schedule sheet matches Team Member on Availability sheet and (2) Start on Schedule sheet matches Date on Availability Sheet.
• My current syntax (returning the #INCORRECT ARGUMENT SET error): =INDEX(COLLECT({Available}, Rescheduled@row, {Who}, Start@row, {When}), 1)

Any thoughts?

Paul McGuinness

Hi @cghallo_Veolia

I think you may have your criteria's in the wrong order? instead of:

=INDEX(COLLECT({Available}, Rescheduled@row, {Who}, Start@row, {When}), 1)

Try:

=INDEX(COLLECT({Available}, {Who}, Rescheduled@row, {When}, Start@row ), 1)

Did that work?

Hope that helps,

Thanks Paul

cghallo_Veolia

Thanks, @Paul McGuinness!

Paul McGuinness

Hi @cghallo_Veolia

I think you may have your criteria's in the wrong order? instead of:

=INDEX(COLLECT({Available}, Rescheduled@row, {Who}, Start@row, {When}), 1)

Try:

=INDEX(COLLECT({Available}, {Who}, Rescheduled@row, {When}, Start@row ), 1)

Did that work?

Hope that helps,

Thanks Paul

cghallo_Veolia

Thanks, @Paul McGuinness!

Kaveri Vipat

Hi cghallo_Veolia 

I hope you are doing well, 

Please create a column for a unique key combination of date and name in both sheets and create a formula for the combination in both sheets like this - (=Start@row + Reschedule@row). 

And then please try this formula - =INDEX({Available?}, MATCH([Unique key]@row, {Unique Key}, 0)) 

I hope this is useful to you, please let me know if you need any other help.  

Have a Good Day. 

Paul McGuinness

No worries @cghallo_Veolia glad it fixed it.