Forum Discussion
True or false based on value in cell being present in another sheet's column
Hi, I need to create a true/false column for rows based on whether or not the number in column A is present in 'Liste Assyst'!AG:AG. Any and all help appreciated! Julie
Hi, fooddotfacts
The formula you could use is CountIf to return true/false results.
In my example below I am checking if the value in column D (on my test sheet) is in the list that is on the "Liste Assyst" sheet in column AG:
=COUNTIF('Liste Assyst'!AG:AG,D1) >0