| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ISBLANK function not working when cell is blank dut to function re | Excel Discussion (Misc queries) | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Hybrid Mode
