Yes.
Put this in G2
=INDEX($D$2:$D$50,MATCH(C2,$A$2:$A$50,0))
Rgds,
ScottO

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