Previous Topic Next Topic

Finding a date (N30) in a date range B5:B30 and returning A3text

Solved/Closed
Kelley - Apr 29, 2015 at 05:15 AM
MaxStart Posts 340 Registration date Tuesday March 3, 2015 Status Moderator Last seen July 3, 2015 - Apr 29, 2015 at 07:06 AM
Hello,

Thank you in advance for helping me... I really appreciate it. I believe I need an =IF formula....

I have a column with different dates in each cell (B25:B34). I also have some random dates listed in other cells (eg, N30). I would like a formula in cell N31 that will look up the date range (B25:B34) and if the date that is in N30 appears in the date range, then produce the result of text "school" (or cell "A3" as the word "school" already appears in that cell). If the date doesn't appear in the range (B25:B34) then leave the cell empty.


1 reply

Answer 1 / 1
MaxStart Posts 340 Registration date Tuesday March 3, 2015 Status Moderator Last seen July 3, 2015 69
Apr 29, 2015 at 06:06 AM 
=IF(COUNTIF(B25:B34,N30),"school","")
0
Kelley
Apr 29, 2015 at 06:10 AM
Dear MaxStart, thank you, thank you thankyou...
So very grateful!
Kelley
0
MaxStart Posts 340 Registration date Tuesday March 3, 2015 Status Moderator Last seen July 3, 2015 69
Apr 29, 2015 at 07:06 AM
u're welcome
0