Need Function Help

  • Thread starter Thread starter TechieGirl
  • Start date Start date
T

TechieGirl

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
 
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.
 
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.
 
Try this:

=COUNTIF(B:B,A1)>0



TechieGirl said:
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.
Click to expand...
 
=ISNUMBER(MATCH(B1,A:A,0))

Did you swap the arguments in the formula?

=ISNUMBER(MATCH(A1,B:B,0))
 
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
 
You're Welcome!

TechieGirl said:
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
Click to expand...
 
Yes I did. Thanks.
The problem was I had included headers and did not adjust the formulas to
start from the correct cell.
 
Back
Top