=IF statement referencing an entire column

Benjamin Brunnette

Hi community,

I'm wondering if there is a way to build an =IF formula while referencing an entire column. for example:

=IF([any value in column B]=A1, true, false)

Thanks!

Kelly Drake

The formula is totally possible! To reference an entire column just use [Column Name]:[Column Name]

You might need to do something like

= IF(CONTAINS(A1, [Column B]:[Column B]), 1, 0)

Kelly Drake

The formula is totally possible! To reference an entire column just use [Column Name]:[Column Name]

You might need to do something like

= IF(CONTAINS(A1, [Column B]:[Column B]), 1, 0)