That's the ticket!...thanks.

"ScottO" wrote:

Try this in F2 ...

=IF(ISNA(MATCH(C2,$A$2:$A$50,0)),"N","Y")

Rgds,
ScottO

"jjjam" wrote in message
...
| 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).
|
|