Stumped - getting #INCORRECT AUGUMENT SET

mcepaiti

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

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))

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))