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?
|