Feb 20 2019 01:28 PM
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
Feb 21 2019 02:26 AM
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
Feb 26 2019 11:00 AM
This question is currently in the Community Discussion space, which is for questions about the Tech Community.
I've moved your question to the Excel space for better visibility.