Who can help identify my issue with cross sheet index matching formula?

Hello,

Wondering if anyone can help me with finding the error in my formula:

=INDEX({Destination Care Fund Statement of Need Range 1}, MATCH({Destination Care Fund Statement of Need Range 2}, [MRN], 0))

Range 1 and range 2 information populated when I clicked the column in the selected sheet from reference another sheet

I am trying to do a cross sheet reference so that the lodging amount will populate in another sheet @ row level if my MRN column matches. All changes I try just give me other errors and this formulas gives and unparseable error.

Find more posts tagged with

Accepted answers

jmyzk_cloudsmart_jp

@MEJ

Please try changing [MRN] to MRN@row.

=INDEX({Destination Care Fund Statement of Need Range 1}, MATCH(MRN@row, {Destination Care Fund Statement of Need Range 2}, 0))

All comments

jmyzk_cloudsmart_jp

@MEJ

Please try changing [MRN] to MRN@row.

=INDEX({Destination Care Fund Statement of Need Range 1}, MATCH(MRN@row, {Destination Care Fund Statement of Need Range 2}, 0))

MEJ

@jmyzk_cloudsmart_jp thank you so much that made it work!!

jmyzk_cloudsmart_jp

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