Help with Index/Match & Column Formulas

Hello,

I am trying to create an index/match function but am receiving a #NO MATCH even though I know the value is in the reference range and I am almost positive my formula is correct. The problem might be that I am referencing a range in the 'match' section that is a column formula. Does anyone know if this is the problem or have any suggestions on what might be causing the no-match?

Below is a screenshot of my tracker and function

Here is the screenshot of the tracker I am pulling from with the Project ID column being my reference range. The reason why it is a column formula is because I am pulling out the "-U" from the column to the left.

Is it possible to create an index/match formula that references another column formula? If not, does anyone have any suggestions to get around this? Thanks!!!

Find more posts tagged with

Accepted answers

heyjay

Can you wrap your Project ID in VALUE() function and see if that works. I am assuming that the Project ID are all numbers.

All comments

heyjay

https://community.smartsheet.com/discussion/119636/help-with-index-match-column-formulas

Yes, you can use a column formula as reference. Just change the reference to that new 'Project ID' column.

Emily Quick

@heyjay I am using the Project ID column as the reference range..

Any ideas on why I am getting a nomatch?

heyjay

Can you wrap your Project ID in VALUE() function and see if that works. I am assuming that the Project ID are all numbers.

Emily Quick

@heyjay that worked! Thank yoU!!

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.