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

Answer 1 / 1
MaxStart Posts 338 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","")
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 Moderator Last seen July 3, 2015 69
Apr 29, 2015 at 07:06 AM
u're welcome

Similar discussions

range of numbers
whatsit -
Mazzaropi -

3 responses
Copy range data in a column to new column.
anthonyishere -
anthonyishere -

6 responses
Excel Macro - Set and autofill a range?
KT -
excel987 -

28 responses
type b its showing b5 and if n its n6
lee -
Ambucias -

1 response
Excel Macro/Code help: Creating sheet for each name in column of another sheet
excelnovice2019 -
vcoolio -

21 responses