Excel return all values from another worksheet column that meets criteria
<p>So i am developing this access sheet for agents daily usage. The principle is that data is entered in "Access Sheet" tab and for daily usage "Search" tab is used which return values from access sheet based on vlookup search. </p>

<p><a href="https://i.stack.imgur.com/xZnBX.jpg" rel="nofollow noreferrer">SEARCH tab</a></p>

<p><a href="https://i.stack.imgur.com/ZP4rj.jpg" rel="nofollow noreferrer">ACCESS SHEET tab</a></p>

<p>What i need is that below search results table, values that meet criteria <code>cellvalue&lt;(Now()-25)</code> at "Access Sheet" tab column <code>J</code> would be returned additionally with information from same rows columns <code>E</code> and <code>I</code>. And a hyperlink like in search table column <code>D</code>.</p>

<p>Formulas i have used in SEARCH sheet to get the search working are:</p>

<p>in table column <code>C</code>:</p>

<pre><code>=IFERROR(VLOOKUP('ACCESS SHEET'!$A6,'ACCESS SHEET'!$B6:$L$997,COLUMNS('ACCESS SHEET'!$E6:'ACCESS SHEET'!E6)+3,FALSE),"")
</code></pre>

<p>in table column <code>H</code>:</p>

<pre><code>=IF(IFERROR(VLOOKUP('ACCESS SHEET'!$A6,'ACCESS SHEET'!$B6:$L$997,COLUMNS('ACCESS SHEET'!$E6:'ACCESS SHEET'!J6)+3,FALSE),"")="","",IFERROR(VLOOKUP('ACCESS SHEET'!$A6,'ACCESS SHEET'!$B6:$L$997,COLUMNS('ACCESS SHEET'!$E6:'ACCESS SHEET'!J6)+3,FALSE),""))
</code></pre>

<p>In all other table cells except columns <code>C</code> and <code>D</code> there are the same formulas</p>

<p>In column <code>D</code> there is a hyperlink based on <code>vlookup</code> result:</p>

<pre><code>=IFERROR(HYPERLINK("#'ACCESS SHEET'!E"&amp;MATCH(C7,'ACCESS SHEET'!$E:$E,0),"Click Here"),"")
</code></pre>

<p>In "access sheet" tab there are formulas only in gray zone columns and they are <code>search(C)</code> and <code>rank+countif(B)</code></p>

<p>Thank you for your help!</p>