Can I use an INDEX formula to retrieve value from another INDEX Formula?

Hello,

I have two similar INDEX formulas, where one works and the other one retrieves #INVALID VALUE error.

They are as follows:

"IF([Nov-19]188 = 0, 0, INDEX($[Jan-19]$119:$[FY50]$119, 1, [Nov-19]188))" - this one works and retrieves the value I want.

"=IF([Nov-19]110 = 0, 0, INDEX($[Jan-19]$189:$[FY50]$189, 1, [Nov-19]110))" - retrieves #INVALID VALUE and line 189 is where the above formula is.

Is it possible to use an INDEX formula to retrieve value from another INDEX Formula?

Find more posts tagged with

Forms

Finance

Formulas

functionality

Accepted answers

Paul Newcome

Yes. That was going to be my next question. Glad you got it figured out! 👍️

All comments

Paul Newcome

What exactly is in [Nov-19]110?

Jose Vale

I have figured out the problem since, the range $[Jan-19]$189:$[FY50]$18 included #INVALID VALUEs which led the formula into error.

Paul Newcome

Yes. That was going to be my next question. Glad you got it figured out! 👍️

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.