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
|