Quick formula question

[jjjam]

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

[ScottO]

Try this in F2 ...

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

Rgds,
ScottO

"jjjam" <[email protected]> wrote in message
news:[email protected]...
| 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).
|
|

[jjjam]

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" <[email protected]> wrote in message
> news:[email protected]...
> | 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).
> |
> |
>
>
>

[jjjam]

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" <[email protected]> wrote in message
> > news:[email protected]...
> > | 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).
> > |
> > |
> >
> >
> >

[ScottO]

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

"jjjam" <[email protected]> wrote in message
news:[email protected]...
| 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" <[email protected]> wrote in message
| > > news:[email protected]...
| > > | 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).
| > > |
| > > |
| > >
| > >
| > >

[jjjam]

ScottO,
....the result is coming up as #N/A. Am I doing something wrong? (obviously
YES).....

=INDEX('March 2005'!D2:D187,MATCH(C2,'March 2005'!A2:A187,0))

"ScottO" wrote:

> Yes.
> Put this in G2
> =INDEX($D$2:$D$50,MATCH(C2,$A$2:$A$50,0))
> Rgds,
> ScottO
>
> "jjjam" <[email protected]> wrote in message
> news:[email protected]...
> | 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" <[email protected]> wrote in message
> | > > news:[email protected]...
> | > > | 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).
> | > > |
> | > > |
> | > >
> | > >
> | > >
>
>
>

[jjjam]

Ignore my last comment. It worked fine. #N/A is the result of a no-match,
when there IS a match, it inserts the contents of D15 as planned.

You are amazing, and should immediately get yourself a cold beer!

"ScottO" wrote:

> Yes.
> Put this in G2
> =INDEX($D$2:$D$50,MATCH(C2,$A$2:$A$50,0))
> Rgds,
> ScottO
>
> "jjjam" <[email protected]> wrote in message
> news:[email protected]...
> | 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" <[email protected]> wrote in message
> | > > news:[email protected]...
> | > > | 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).
> | > > |
> | > > |
> | > >
> | > >
> | > >
>
>
>

[ScottO]

The syntax of your formula looks right, so my guess is that the value in C2
doesn't exist in the range 'March 2005'!A2:A187 ... but I'm sure that you've
already checked for that.
I don't have any other suggestions.
Rgds,
ScottO

"jjjam" <[email protected]> wrote in message
news:[email protected]...
| ScottO,
| ...the result is coming up as #N/A. Am I doing something wrong?
(obviously
| YES).....
|
| =INDEX('March 2005'!D2:D187,MATCH(C2,'March 2005'!A2:A187,0))
|
| "ScottO" wrote:
|
| > Yes.
| > Put this in G2
| > =INDEX($D$2:$D$50,MATCH(C2,$A$2:$A$50,0))
| > Rgds,
| > ScottO
| >
| > "jjjam" <[email protected]> wrote in message
| > news:[email protected]...
| > | 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" <[email protected]> wrote in message
| > | > > news:[email protected]...
| > | > > | 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).
| > | > > |
| > | > > |
| > | > >
| > | > >
| > | > >
| >
| >
| >

[ScottO]

Glad it worked out for you.
S

"jjjam" <[email protected]> wrote in message
news:[email protected]...
| Ignore my last comment. It worked fine. #N/A is the result of a
no-match,
| when there IS a match, it inserts the contents of D15 as planned.
|
| You are amazing, and should immediately get yourself a cold beer!
|
| "ScottO" wrote:
|
| > Yes.
| > Put this in G2
| > =INDEX($D$2:$D$50,MATCH(C2,$A$2:$A$50,0))
| > Rgds,
| > ScottO
| >
| > "jjjam" <[email protected]> wrote in message
| > news:[email protected]...
| > | 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" <[email protected]> wrote in message
| > | > > news:[email protected]...
| > | > > | 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).
| > | > > |
| > | > > |
| > | > >
| > | > >
| > | > >
| >
| >
| >