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

Jason S.

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!

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")

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")