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!
Answers
-
@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.
Matt Lynn
-
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?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!