index match using multiple critieria

roya · 2025-09-19T21:18:12+00:00

Hello, I want to use a formula using INDEX/ MATCH Function using multiple criteria to get a single value I am trying to get a value of Column Description from File 2 based on matching Source System ,Table name and Attribute Field Index ( as the column names may be different ) The formula Im using gets me an INVALID…

roya

Hello, I want to use a formula using INDEX/ MATCH Function using multiple criteria to get a single value
I am trying to get a value of Column Description from File 2 based on matching Source System ,Table name and Attribute Field Index ( as the column names may be different )

The formula Im using gets me an INVALID OPERATION ERROR

Formula : !=INDEX({File2 Column Desc}, MATCH(System@row + [Table Name ]@row + [Attribute Field_Index]@row , {File2-SourceSystem} + {File2-Table Name} + {File 2 Column Position}, 0))

Please help me figure out what I may be doing wrong and how to resolve this formula or use some other formula

Find more posts tagged with

Formulas

Accepted answers

All comments

There are no accepted answers yet

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.