consolidated search

[armour919]

I have a data table that has 5 columns - Category, Department, owner, Start Date, Finish date. The input table has roughly 200 projects in it and I want to pull the name of the category and department based on the start date but I do not know how to consolidate the return not to show the blanks that are not true for the logic.

	a	b	c	d	e
1	Category	Dept	Owner	Start	Finish
2	Campaign	MKTG	Eric	11/2/16	2/2/17
3	Campaign	MKTG	Eric	10/30/16	2/2/17
4	Deal	Sales	Seth	11/15/16	2/2/17
5	Deal	Sales	Seth	11/2/16	2/2/17

<tbody>
</tbody>

I would like to reference a start date cell and when I place the start date of 11/2/16

I would like the following to be displayed

	a	b	c	d	e
1	Category	Dept	Owner	Start
2	Campaign	MKTG	Eric	11/2/16
3	Deal	Sales	Seth	11/2/16

<tbody>
</tbody>

its not as simple as a if statement because it would return a blank for row 3 and 4 as they do not meet the start date, how do I use the small function with the row function to pull the correct information?

 

[Gerald Higgins]

Why not just use the Data Filter option ?

 

[armour919]

bc if I was doing it once, then yes, but I am trying to pull the information through the month. Meaning, I have one input form but need to have the projects by start date broken out in different sections depending on the month selected.

 

[Gerald Higgins]

OK, sorry but I don't know what you mean.

Maybe someone else can interpret this ?