IF INDEX MATCH function has circular reference

Hello all,

the following formular gives me a #circular reference mistake. Based on the below can anyone see already why this might be th case?

=IF(INDEX({Vertical}, MATCH([ERP Item Number]@row, {ERP Item Number}, 0)) = [CHECK Vertical]@row, "TRUE", INDEX({Vertical}, MATCH([ERP Item Number]@row, {ERP Item Number}, 0)))

Let me know if you need more context to identify what the mistake might be.

Many thanks,

Dennis

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Do any of the cells or ranges referenced in the formula contain a formula or cell reference to the column the formula is in?

All comments

Paul Newcome

Do any of the cells or ranges referenced in the formula contain a formula or cell reference to the column the formula is in?

Dennis92

Hey Paul,

thanks for that question :D Check Vertical Row was actually the reference in the same cell as the formula. Changed this to the correct cell reference and now it works just fine.

Cheers and have a great weekend,

Dennis

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