Excel: check if a particular value occurs in an entire column 2

[miraclemaker]

Should be an easy for those of you who know their Excel:

How to I check if the value of a particular cell (ie A1), appears in an entire column (say column C)

thanks guys!

 

[koresnordic]

try = vlookup(a1,c:c,1,true) Will give a #N/A is not found or repeat the value if found.



Graham

 

[ETID]

or... an alternate

=countif(c:c,a1)

 

[miraclemaker]

Thanks fellas.