I need to know how to compare a cell address in one column and find if that
cell location is in another column.

I thought that i would use the if function and my formula was
=if(e1=n4:n300,true,false) but this does not seem to work any help would be
appreciated.