Need Function Help
 

Hi,

I have looked up the search, vlookup, insa and if functions and I am still a
little lost. I need a funtion that will look up a value or cell in a column
and return true or false.
Basically, if (the value of A1 is equal to any value in C:C then True,False)

Like so:
A B C
1 Monday January FALSE
2 Tuesday Thursday TRUE
3 Wednesday March FALSE
4 Thursday Tuesday TRUE
5 Friday May FALSE
6 Saturday Saturday TRUE
7 Sunday July FALSE

Need Function Help
 

Your sample data doesn't match your explanation.

Your sample data is being compared as "if B=A, true, if not false".

Try this:

=ISNUMBER(MATCH(B1,A:A,0))

Copy down as needed.

--
Biff
Microsoft Excel MVP


"TechieGirl" wrote in message
...
Hi,

I have looked up the search, vlookup, insa and if functions and I am still
a
little lost. I need a funtion that will look up a value or cell in a
column
and return true or false.
Basically, if (the value of A1 is equal to any value in C:C then
True,False)

Like so:
A B C
1 Monday January FALSE
2 Tuesday Thursday TRUE
3 Wednesday March FALSE
4 Thursday Tuesday TRUE
5 Friday May FALSE
6 Saturday Saturday TRUE
7 Sunday July FALSE

Need Function Help
 

Hi T.

Thanks so much for ignoring my huge typo.
The question should have read"Basically, if (the value of A1 is equal to any
value in B:B then True,False)"

The formula that you provided should work, however I am getting False for
fields that should be true.

Monday January FALSE
Tuesday Sunday FALSE
WednesdayMarch FALSE
Thursday Thursday FALSE
Friday May TRUE
Saturday Tuesday FALSE
Sunday July TRUE


There should be TRUE for C2,C4 & C7. Also C5 should be false.


"T. Valko" wrote:

Your sample data doesn't match your explanation.

Your sample data is being compared as "if B=A, true, if not false".

Try this:

=ISNUMBER(MATCH(B1,A:A,0))

Copy down as needed.

--
Biff
Microsoft Excel MVP


"TechieGirl" wrote in message
...
Hi,

I have looked up the search, vlookup, insa and if functions and I am still
a
little lost. I need a funtion that will look up a value or cell in a
column
and return true or false.
Basically, if (the value of A1 is equal to any value in C:C then
True,False)

Like so:
A B C
1 Monday January FALSE
2 Tuesday Thursday TRUE
3 Wednesday March FALSE
4 Thursday Tuesday TRUE
5 Friday May FALSE
6 Saturday Saturday TRUE
7 Sunday July FALSE

Need Function Help
 

Try this:

=COUNTIF(B:B,A1)0



"TechieGirl" wrote:

Hi T.

Thanks so much for ignoring my huge typo.
The question should have read"Basically, if (the value of A1 is equal to any
value in B:B then True,False)"

The formula that you provided should work, however I am getting False for
fields that should be true.

Monday January FALSE
Tuesday Sunday FALSE
WednesdayMarch FALSE
Thursday Thursday FALSE
Friday May TRUE
Saturday Tuesday FALSE
Sunday July TRUE


There should be TRUE for C2,C4 & C7. Also C5 should be false.


"T. Valko" wrote:

Your sample data doesn't match your explanation.

Your sample data is being compared as "if B=A, true, if not false".

Try this:

=ISNUMBER(MATCH(B1,A:A,0))

Copy down as needed.

--
Biff
Microsoft Excel MVP


"TechieGirl" wrote in message
...
Hi,

I have looked up the search, vlookup, insa and if functions and I am still
a
little lost. I need a funtion that will look up a value or cell in a
column
and return true or false.
Basically, if (the value of A1 is equal to any value in C:C then
True,False)

Like so:
A B C
1 Monday January FALSE
2 Tuesday Thursday TRUE
3 Wednesday March FALSE
4 Thursday Tuesday TRUE
5 Friday May FALSE
6 Saturday Saturday TRUE
7 Sunday July FALSE

Need Function Help
 

=ISNUMBER(MATCH(B1,A:A,0))

Did you swap the arguments in the formula?

=ISNUMBER(MATCH(A1,B:B,0))


--
Biff
Microsoft Excel MVP


"TechieGirl" wrote in message
...
Hi T.

Thanks so much for ignoring my huge typo.
The question should have read"Basically, if (the value of A1 is equal to
any
value in B:B then True,False)"

The formula that you provided should work, however I am getting False for
fields that should be true.

Monday January FALSE
Tuesday Sunday FALSE
WednesdayMarch FALSE
Thursday Thursday FALSE
Friday May TRUE
Saturday Tuesday FALSE
Sunday July TRUE


There should be TRUE for C2,C4 & C7. Also C5 should be false.


"T. Valko" wrote:

Your sample data doesn't match your explanation.

Your sample data is being compared as "if B=A, true, if not false".

Try this:

=ISNUMBER(MATCH(B1,A:A,0))

Copy down as needed.

--
Biff
Microsoft Excel MVP


"TechieGirl" wrote in message
...
Hi,

I have looked up the search, vlookup, insa and if functions and I am
still
a
little lost. I need a funtion that will look up a value or cell in a
column
and return true or false.
Basically, if (the value of A1 is equal to any value in C:C then
True,False)

Like so:
A B C
1 Monday January FALSE
2 Tuesday Thursday TRUE
3 Wednesday March FALSE
4 Thursday Tuesday TRUE
5 Friday May FALSE
6 Saturday Saturday TRUE
7 Sunday July FALSE

Need Function Help
 

SIGH! I am so very sorry everyone. I was in panic mode and making mistakes
left and right.
Both of these answers are perfect and did exactly what I needed. I just
needed to calm down and actually look at what I was trying to do.
Thanks very much T. and Mama

"Teethless mama" wrote:

Try this:

=COUNTIF(B:B,A1)0



"TechieGirl" wrote:

Hi T.

Thanks so much for ignoring my huge typo.
The question should have read"Basically, if (the value of A1 is equal to any
value in B:B then True,False)"

The formula that you provided should work, however I am getting False for
fields that should be true.

Monday January FALSE
Tuesday Sunday FALSE
WednesdayMarch FALSE
Thursday Thursday FALSE
Friday May TRUE
Saturday Tuesday FALSE
Sunday July TRUE


There should be TRUE for C2,C4 & C7. Also C5 should be false.


"T. Valko" wrote:

Your sample data doesn't match your explanation.

Your sample data is being compared as "if B=A, true, if not false".

Try this:

=ISNUMBER(MATCH(B1,A:A,0))

Copy down as needed.

--
Biff
Microsoft Excel MVP


"TechieGirl" wrote in message
...
Hi,

I have looked up the search, vlookup, insa and if functions and I am still
a
little lost. I need a funtion that will look up a value or cell in a
column
and return true or false.
Basically, if (the value of A1 is equal to any value in C:C then
True,False)

Like so:
A B C
1 Monday January FALSE
2 Tuesday Thursday TRUE
3 Wednesday March FALSE
4 Thursday Tuesday TRUE
5 Friday May FALSE
6 Saturday Saturday TRUE
7 Sunday July FALSE

Need Function Help
 

You're Welcome!

"TechieGirl" wrote:

SIGH! I am so very sorry everyone. I was in panic mode and making mistakes
left and right.
Both of these answers are perfect and did exactly what I needed. I just
needed to calm down and actually look at what I was trying to do.
Thanks very much T. and Mama

"Teethless mama" wrote:

Try this:

=COUNTIF(B:B,A1)0



"TechieGirl" wrote:

Hi T.

Thanks so much for ignoring my huge typo.
The question should have read"Basically, if (the value of A1 is equal to any
value in B:B then True,False)"

The formula that you provided should work, however I am getting False for
fields that should be true.

Monday January FALSE
Tuesday Sunday FALSE
WednesdayMarch FALSE
Thursday Thursday FALSE
Friday May TRUE
Saturday Tuesday FALSE
Sunday July TRUE


There should be TRUE for C2,C4 & C7. Also C5 should be false.


"T. Valko" wrote:

Your sample data doesn't match your explanation.

Your sample data is being compared as "if B=A, true, if not false".

Try this:

=ISNUMBER(MATCH(B1,A:A,0))

Copy down as needed.

--
Biff
Microsoft Excel MVP


"TechieGirl" wrote in message
...
Hi,

I have looked up the search, vlookup, insa and if functions and I am still
a
little lost. I need a funtion that will look up a value or cell in a
column
and return true or false.
Basically, if (the value of A1 is equal to any value in C:C then
True,False)

Like so:
A B C
1 Monday January FALSE
2 Tuesday Thursday TRUE
3 Wednesday March FALSE
4 Thursday Tuesday TRUE
5 Friday May FALSE
6 Saturday Saturday TRUE
7 Sunday July FALSE

Need Function Help
 

Yes I did. Thanks.
The problem was I had included headers and did not adjust the formulas to
start from the correct cell.

"T. Valko" wrote:

=ISNUMBER(MATCH(B1,A:A,0))

Did you swap the arguments in the formula?

=ISNUMBER(MATCH(A1,B:B,0))


--
Biff
Microsoft Excel MVP


"TechieGirl" wrote in message
...
Hi T.

Thanks so much for ignoring my huge typo.
The question should have read"Basically, if (the value of A1 is equal to
any
value in B:B then True,False)"

The formula that you provided should work, however I am getting False for
fields that should be true.

Monday January FALSE
Tuesday Sunday FALSE
WednesdayMarch FALSE
Thursday Thursday FALSE
Friday May TRUE
Saturday Tuesday FALSE
Sunday July TRUE


There should be TRUE for C2,C4 & C7. Also C5 should be false.


"T. Valko" wrote:

Your sample data doesn't match your explanation.

Your sample data is being compared as "if B=A, true, if not false".

Try this:

=ISNUMBER(MATCH(B1,A:A,0))

Copy down as needed.

--
Biff
Microsoft Excel MVP


"TechieGirl" wrote in message
...
Hi,

I have looked up the search, vlookup, insa and if functions and I am
still
a
little lost. I need a funtion that will look up a value or cell in a
column
and return true or false.
Basically, if (the value of A1 is equal to any value in C:C then
True,False)

Like so:
A B C
1 Monday January FALSE
2 Tuesday Thursday TRUE
3 Wednesday March FALSE
4 Thursday Tuesday TRUE
5 Friday May FALSE
6 Saturday Saturday TRUE
7 Sunday July FALSE

Need Function Help
 

Ok, good deal. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"TechieGirl" wrote in message
...
Yes I did. Thanks.
The problem was I had included headers and did not adjust the formulas to
start from the correct cell.

"T. Valko" wrote:

=ISNUMBER(MATCH(B1,A:A,0))

Did you swap the arguments in the formula?

=ISNUMBER(MATCH(A1,B:B,0))


--
Biff
Microsoft Excel MVP


"TechieGirl" wrote in message
...
Hi T.

Thanks so much for ignoring my huge typo.
The question should have read"Basically, if (the value of A1 is equal
to
any
value in B:B then True,False)"

The formula that you provided should work, however I am getting False
for
fields that should be true.

Monday January FALSE
Tuesday Sunday FALSE
WednesdayMarch FALSE
Thursday Thursday FALSE
Friday May TRUE
Saturday Tuesday FALSE
Sunday July TRUE


There should be TRUE for C2,C4 & C7. Also C5 should be false.


"T. Valko" wrote:

Your sample data doesn't match your explanation.

Your sample data is being compared as "if B=A, true, if not false".

Try this:

=ISNUMBER(MATCH(B1,A:A,0))

Copy down as needed.

--
Biff
Microsoft Excel MVP


"TechieGirl" wrote in message
...
Hi,

I have looked up the search, vlookup, insa and if functions and I am
still
a
little lost. I need a funtion that will look up a value or cell in a
column
and return true or false.
Basically, if (the value of A1 is equal to any value in C:C then
True,False)

Like so:
A B C
1 Monday January FALSE
2 Tuesday Thursday TRUE
3 Wednesday March FALSE
4 Thursday Tuesday TRUE
5 Friday May FALSE
6 Saturday Saturday TRUE
7 Sunday July FALSE