ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Quick formula question (https://www.excelbanter.com/excel-worksheet-functions/34185-quick-formula-question.html)

jjjam
Quick formula question
 
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" 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).
|
|

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

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

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



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




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




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



ScottO
Glad it worked out for you.
S

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




All times are GMT +1. The time now is 01:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com