TB's Code Library
If it ain't tight, it ain't right!
Search
Sunday, May 22, 2005
Yes / No check for 1 cell to everything in the same row in Excel
Excel statement that displays “yes� or “no� if content in cell C1 equals or doesn’t equal anything in column A
=IF(ISNUMBER(MATCH(C1,A:A,0)),"Yes","No")
Newer Post
Older Post
Home