Would it be possible to modify the formula below to include the following
logic when a match is found?
Example:
If the match to C2 is found in cell $A$15, take cell $D$15 and place it in G2.



"jjjam" wrote:

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).
|
|