Formula Help

Hello my friends - I know someone can help me figure this out :)

I finally got my Client Name match formula to work! Now I am having issues pulling matching fields into my lookup sheet. I get "No Match Found" on all subsequent fields I need to pull. And I have validated there is data contained in each of the fields.

=IF(ISERROR(INDEX({Client Savings Analysis Master | Live Count}, MATCH([Client Details]2, {Client Savings Analysis Master | Client Name}, 0))), "No Match Found", INDEX({Client Savings Analysis Master | Live Count}, MATCH([Client Details]2, {Client Savings Analysis Master | Client Name}, 0)))

Thank you in advance!

Find more posts tagged with

Accepted answers

All comments

Matt Lynn ACT

@Michele Rosenberg Does any of your source data that you're using as criteria, such as {Client Savings Analysis Master | Client Name}, have any invalid or error data in those values? If so put those formulas in a iferror(,"") function. The match portion of the function won't work if it has errors thus triggering the "No Match Found" warning.

Michele Rosenberg

Thank you @Matt Lynn-PCG,

I do not see any fields with errors in them, there are some fields which are blank but not on my test client. Could that be causing it? Can I take that out and allow the formula to still match correctly? How would you resolve?

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.