Stumped - getting #INCORRECT AUGUMENT SET

Not sure what I am not seeing. I had a longer nested string, and paired it down to a single argument, yet I am not seeing the issue:

=IFERROR(INDEX({All Stores Nexus ID Segments Segment}, MATCH([Nexus CRM ID]@row), {All Stores Nexus ID Segments CRM2}, 0), "")

The the match ref columns are the same properties.

Thanks in advance for any advise.

Mark C

Find more posts tagged with

Accepted answers

mcepaiti

I figured it out... simple fix

=INDEX({All Stores Nexus ID Segments Segment}, MATCH([Nexus CRM ID]@row, {All Stores Nexus ID Segments CRM}, 0))

All comments

James Keuning

What happens if you break the MATCH out into its own field, and reference that field in the INDEX column?

mcepaiti

Not sure I understand.

mcepaiti

I figured it out... simple fix

=INDEX({All Stores Nexus ID Segments Segment}, MATCH([Nexus CRM ID]@row, {All Stores Nexus ID Segments CRM}, 0))

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.