Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup
This should be easy, but for the life of me I can't figure it out. I
have one cell that has a date (a1) in it. I want to verify that date against a range of dates (b1:b4) (it needs to be in that range) that I have in a column, while using an if/and statement. The statement I want to use is something to the effect of (in words): if a1 is a thursday and is in the range b1:b4, give me a something, otherwise give me something else. Am I making this harder than it should be? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup
=IF(AND(WEEKDAY(A1)=5,ISNUMBER(MATCH(A1,B1:B4,0))) ,"something","something
else") -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) wrote in message oups.com... This should be easy, but for the life of me I can't figure it out. I have one cell that has a date (a1) in it. I want to verify that date against a range of dates (b1:b4) (it needs to be in that range) that I have in a column, while using an if/and statement. The statement I want to use is something to the effect of (in words): if a1 is a thursday and is in the range b1:b4, give me a something, otherwise give me something else. Am I making this harder than it should be? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup
Michael,
If you need an exact match: =IF(ISERROR(MATCH(A1,B1:B4,FALSE)),"a something","something else") If you need it within the range defined by the dates in B1:B4 =IF(AND(A1=MIN(B1:B4),A1<=MAX(B1:B4)),"something else","a something") HTH, Bernie MS Excel MVP wrote in message oups.com... This should be easy, but for the life of me I can't figure it out. I have one cell that has a date (a1) in it. I want to verify that date against a range of dates (b1:b4) (it needs to be in that range) that I have in a column, while using an if/and statement. The statement I want to use is something to the effect of (in words): if a1 is a thursday and is in the range b1:b4, give me a something, otherwise give me something else. Am I making this harder than it should be? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup
Try one of these:
=IF(AND(TEXT(A1,"DDD")="THU",COUNTIF(B1:B4,A1)),"U se this","otherwise this") or =IF(AND(WEEKDAY(N(A1))=5,COUNTIF(B1:B4,A1)),"Use this","otherwise this") Does that help? *********** Regards, Ron XL2002, WinXP " wrote: This should be easy, but for the life of me I can't figure it out. I have one cell that has a date (a1) in it. I want to verify that date against a range of dates (b1:b4) (it needs to be in that range) that I have in a column, while using an if/and statement. The statement I want to use is something to the effect of (in words): if a1 is a thursday and is in the range b1:b4, give me a something, otherwise give me something else. Am I making this harder than it should be? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup
That did it! I tried the other two, but couldn't get them to work.
This one was awesome. Thanks a lot for your help... Ron Coderre wrote: Try one of these: =IF(AND(TEXT(A1,"DDD")="THU",COUNTIF(B1:B4,A1)),"U se this","otherwise this") or =IF(AND(WEEKDAY(N(A1))=5,COUNTIF(B1:B4,A1)),"Use this","otherwise this") Does that help? *********** Regards, Ron XL2002, WinXP " wrote: This should be easy, but for the life of me I can't figure it out. I have one cell that has a date (a1) in it. I want to verify that date against a range of dates (b1:b4) (it needs to be in that range) that I have in a column, while using an if/and statement. The statement I want to use is something to the effect of (in words): if a1 is a thursday and is in the range b1:b4, give me a something, otherwise give me something else. Am I making this harder than it should be? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup
Thanks for the feedback....I'm glad that worked for you.
*********** Regards, Ron XL2002, WinXP " wrote: That did it! I tried the other two, but couldn't get them to work. This one was awesome. Thanks a lot for your help... Ron Coderre wrote: Try one of these: =IF(AND(TEXT(A1,"DDD")="THU",COUNTIF(B1:B4,A1)),"U se this","otherwise this") or =IF(AND(WEEKDAY(N(A1))=5,COUNTIF(B1:B4,A1)),"Use this","otherwise this") Does that help? *********** Regards, Ron XL2002, WinXP " wrote: This should be easy, but for the life of me I can't figure it out. I have one cell that has a date (a1) in it. I want to verify that date against a range of dates (b1:b4) (it needs to be in that range) that I have in a column, while using an if/and statement. The statement I want to use is something to the effect of (in words): if a1 is a thursday and is in the range b1:b4, give me a something, otherwise give me something else. Am I making this harder than it should be? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Another way to lookup data | Excel Worksheet Functions | |||
lookup more than one cell | Excel Worksheet Functions | |||
Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
Lookup function w/Text and Year | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |