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 339 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.

Finding a date (N30) in a date range B5:B30 and returning A3text
Apple airtag range - Guide
Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as range names. ✓ - Excel Forum
Excel if range of cells contains specific text then return value ✓ - Excel Forum
Formula for finding position in excel - Office Software Forum
Finding @ on keyboard - Guide

1 response

Answer 1 / 1

MaxStart Posts 339 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 339 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

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

How to calculate position (1st,2nd,3rd) in excel....?

Excel Macro - Set and autofill a range?

Modern Warfare 2 online cant find matchs why

Calculation of positions in excel

Similar discussions

Subscribe To Our Newsletter!