True or false based on value in cell being present in another sheet's column

Copper Contributor

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

2 Replies

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

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.