I have a column of text values in column C (over 600 rows), and a smaller list in column H (55 rows). I need a formula in column F, that takes the value in C, and if it is found in the list in H, will return either a YES or a 1, and if it is not found will return a NO or a 0.
Bookmarks