If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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 |
#8
|
|||
|
|||
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 |
#9
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|