Index Match

duncbro

I have used an index match in several columns of a grid. However, this one column is giving me trouble.

Can anyone review and let me know what I am overlooking?

=INDEX({Fiscal Listing FY22 (4/11) Range 1}, MATCH(Funding@row, {Fiscal Listing FY22 (4/11) Range 2}, 0))

Find more posts tagged with

Accepted answers

All comments

Jason Tarpinian

Without too much more data, can't say exactly what is happening, your syntax looks correct. Are your ranges the same size? Make sure they are the same sheet, or at least referencing the same size ranges.

duncbro

Yes, the ranges are the same sizes. The issue was with the column property.

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.