Search a specific value within a range

Hi, in this example, I would like to search a value (each cell in Column 5), within a range in Column4. I tried using formula HAS and CONTAINS, but it seems the criteria or search value is not recognized when I click on a cell in Column 5.

Appreciate if you can help me to find a way to pull this off.

Best regards,

Find more posts tagged with

Formulas

Accepted answers

Genevieve P.

Hi @lschek1

I agree that it would be helpful to know a bit more about what you're looking to do! Are you just checking to see if the value in your Column5 appears anywhere in Column4?

If so, try something like this:

=IF(CONTAINS([Column5]@row, [Column4]:[Column4]), "Yes", "No")

Cheers,

Genevieve

All comments

Andrée Starå

Hi @lschek1

I hope you're well and safe!

Can you share the formula you're testing and elaborate on what's not working?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Genevieve P.

Hi @lschek1

I agree that it would be helpful to know a bit more about what you're looking to do! Are you just checking to see if the value in your Column5 appears anywhere in Column4?

If so, try something like this:

=IF(CONTAINS([Column5]@row, [Column4]:[Column4]), "Yes", "No")

Cheers,

Genevieve

lschek1

Hi @Genevieve P. @Andrée Starå , yes I was able to solve, I changed something in the formula and did something similar to what Genevieve suggested. Many thanks.

Andrée Starå

@lschek1

Excellent!

Glad you got it working!

Happy to help!

✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

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