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 338 Registration date Tuesday March 3, 2015 Status Contributor 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 response

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

Similar discussions

Excel using date range and formula on separate sheets
Action -
vcoolio -

1 response
Excel Macro - Set and autofill a range?
KT -
excel987 -

28 responses
How to find my Facebook ID?
Urstrulynaveennaveenreddy -
ac3mark -

1 response
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Doesn't detect home WiFi on iPhone
Bill -
anna -

16 responses