Lookup

  • Thread starter Thread starter michael.lajoie
  • Start date Start date
M

michael.lajoie

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?
 
=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)
 
=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)
 
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
 
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
 
Try one of these:

=IF(AND(TEXT(A1,"DDD")="THU",COUNTIF(B1:B4,A1)),"Use 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
 
Try one of these:

=IF(AND(TEXT(A1,"DDD")="THU",COUNTIF(B1:B4,A1)),"Use 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
 
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...
 
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...
 
Thanks for the feedback....I'm glad that worked for you.

***********
Regards,
Ron

XL2002, WinXP
 
Thanks for the feedback....I'm glad that worked for you.

***********
Regards,
Ron

XL2002, WinXP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup / Summary Table 8
Comparison of columns using Conditional Formatting 3
SUMIF date criteria 3
Formula to display nearest following Thursday in mm/dd/yyyy format 1
Fixing date of entry 14
special case of sumif 4
excel "IF" function... is this possible ? 0
Lookup returning wrong results 0

Back
Top