Incorrect Argument Set

System

This discussion was created from comments split from: #INCORRECT ARGUMENT SET.

RichC

Hi @Brian_Richardson

Thanks in advance for your help. I have a similar #INCORRECT ARGUMENT SET driving me crazy. Here's my formula

=INDEX(COLLECT({UpdatesforSpecificWeek}, {Week}, $[Week End]@row), $[Row Number]@row, [Week1]$1)

Where {UpdatesforSpecificWeek} is a range in another sheet of updates for each week of the year (columns) by each employee (rows). The first column in that range is [Week End]. Since the sheet has updates for multiple weeks in it, I'm trying to collect the range of updates for a particular week by collecting each row for the updates range that meets the criteria of $[Week End]@row and use that range to pull a specific value in it by using index with a specific row (contained in $[Row Number]@row) and column (contained in [Week1]$1).

Brian_Richardson

Disregard my earlier post. The issue is that COLLECT doesn't return multiple columns. So when you attempt to INDEX the collection and provide a relative column position, it's failing. A COLLECT returns a single array of results, so you should only use the row_index argument to pick from the results.

Marcela

Hello @RichC,

I am tagging you to ensure that Brian's response doesn't go unnoticed.

Cheers,
Marce