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!
Best Answer
-
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")
Best,
Zach Hall
Training Delivery Manager / Charter Communications
Answers
-
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")
Best,
Zach Hall
Training Delivery Manager / Charter Communications
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.1K Get Help
- 444 Global Discussions
- 141 Industry Talk
- 472 Announcements
- 5K Ideas & Feature Requests
- 83 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!