If a value from Column A is found in Column B, can the occurrence be shown as "true".

Hello,

I am looking for the easiest formula to help show when a value from Column A shows up in Column B. If it is possible, I do not want to enter each value found in Column A in a formula, as these values are actively changing. (Note: The list "Column A" is also extensive so manually entering each Active Project would be burdensome)

Column A= Active Projects - Store #

Column B= Store #

Column A is a list of projects that are currently active, while Column B is a list of all sites that have already been visited (entered through a form). My end goal is to have a chart or graph showing the active projects that have already been visited, and which ones have not.

Thanks!

Find more posts tagged with

Construction

Formulas

Dashboards

Project Management

Countif

Accepted answers

Zachary Hall

Here is a basic formula you could put in Column C as a Column formula that would return True or False for every row.

=IFERROR(IF(MATCH([Column B]@row, [Column A]:[Column A],0)>0,"True"),"False")

All comments

Zachary Hall

Here is a basic formula you could put in Column C as a Column formula that would return True or False for every row.

=IFERROR(IF(MATCH([Column B]@row, [Column A]:[Column A],0)>0,"True"),"False")

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.