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
Check out the Formula Handbook template!