Formula Help

I am getting an incorrect argument error with the below formula.

I am trying to collect data from different sheets based on whether the cell value in the Airside / Landside column is Airside or Landside.

=IFERROR(IF([Airside / Landside]@row = "Airside", INDEX(COLLECT({EqNo}, {Employee ID}, [Employee #]@row), 1), IF([Airside / Landside]@row = "Landside", INDEX(COLLECT({LSEQNo}, {LS Employee Number}, [Employee #]@row), 1),"Employee Not Listed")

Thanks!

Find more posts tagged with

Accepted answers

Paul Newcome

Try inserting a second and third closing parenthesis after the final INDEX/COLLECT.

[Employee #]@row), 1))),"Employee Not Listed")

Jeff Reisman

@Ronald Anderson

The incorrect argument set error is being thrown because of syntax and a missing argument.

Let's start with the nested IFs. You have two IF statements, so for sure at the end of your IFs you'll need two end parentheses, because you have to close out both IFs. So to start with, add a second end parentheses after "Employee Not Listed")

Next, you have your IFERROR. The syntax for IFERROR is =IFERROR(value/formula, value if there's an error). Right now you just just have the =IFERROR(value/formula) part, so you're missing the value if there's an error. If you want "Employee Not Listed" to be the value if error, try closing off your two IFs before that value (see bold end parentheses):

If you want some other value for the error condition, close the IFs after "Employee Not Listed" and specify that other value afterward:

All comments

Paul Newcome

Try inserting a second and third closing parenthesis after the final INDEX/COLLECT.

[Employee #]@row), 1))),"Employee Not Listed")

Jeff Reisman

@Ronald Anderson

The incorrect argument set error is being thrown because of syntax and a missing argument.

If you want some other value for the error condition, close the IFs after "Employee Not Listed" and specify that other value afterward:

Ronald Anderson

Thank you both for your helpful and quick response!

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.