# Find Data and Paste

On sheet 4 I need to search column E and find each cell that has a date that is within 90 Days, and then copy the data in Column C and Column E of the matching rows and place it in Sheet ("Overview") cell A4 and B4.

Basically I need to display all the data in Column C and Column E that is within 90 Days, if it is past 90 or not yet to 90 then ignore.
###### Who is Participating?

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Microsoft Excel ExpertCommented:
maybe there are better ways to do this,  based on what i understood from your question, i have came up with the attached formula solution.
Book1.xlsx
Incident ResponderAuthor Commented:
Professor,
Thanks for the input, I am just needing the companies that are within 90 Days of the date in Column E, all the data is past today's date, which I am no longer concerned with.  Also I need to ensure there are no empty spaces and it is one continuous list.
Excel & VBA ExpertCommented:
Based on Professor's workbook, try this Array Formula which requires confirmation with Ctrl+Shift+Enter instead of Enter alone.

In A4
``````=IFERROR(INDEX(Sheet4!D\$2:D\$250,SMALL(IF(Sheet4!\$E\$2:\$E\$250>=TODAY(),IF(Sheet4!\$E\$2:\$E\$250<=TODAY()+90,ROW(Sheet4!\$E\$2:\$E\$250)-ROW(Sheet4!\$E\$2)+1)),ROWS(A\$4:A4))),"")
``````
then copy it across and down until you get blank cells.

For detail, please refer to the attached.
Copy-of-Book1.xlsx

Experts Exchange Solution brought to you by