Simple question but I'm stumped. How do I write a formula that will take a
value from a cell (C2), scan a column (A2:A50) for the value in C2, then put
a Y or a N in F2 if the value is found (Y) or not found (N).