<div>
Thanks brain solved it...excellent feedback..
</div>


Thanks brain solved it...excellent feedback..

<div>
Shorter option:<br />
<br />
=IF(H4&lt;&gt;&quot;&quot;,&quot;&quot;,IFERROR(VLOO<wbr />KUP($A4,'D<wbr />ata Entry'!$B$6:$EA$863,75,0),<wbr />&quot;&quot;))
</div>


Shorter option:

=IF(H4<>"","",IFERROR(VLOOKUP($A4,'Data Entry'!$B$6:$EA$863,75,0),""))

<div>
<div class="content wysiwyg-content">
Hi Experts using excel 2010<br />
<br />
i have the folllowing formula which i cannot get to work....<br />
<br />
if H4 has a date then G4 is blank (irrespective of the fact that G4 has a formula in it) and if H4 is blank (but has a formula in the cell) then G4..<br />
<br />
=IF(H4=&quot;&quot;,IF(ISNA(VLOOKUP(<wbr />$A4,'Data Entry'!$B$6:$EA$863,75,0))<wbr />,&quot;&quot;,(VLOOK<wbr />UP($A4,'Da<wbr />ta Entry'!$B$6:$EA$863,75,0))<wbr />),IF(H4&lt;&gt;&quot;<wbr />&quot;,&quot;&quot;,IF(IS<wbr />NA(VLOOKUP<wbr />($A4,'Data<wbr /> Entry'!$B$6:$EA$863,75,0))<wbr />,&quot;&quot;,(VLOOK<wbr />UP($A4,'Da<wbr />ta Entry'!$B$6:$EA$863,75,0))<wbr />)))
</div>
</div>


Hi Experts using excel 2010

i have the folllowing formula which i cannot get to work....

if H4 has a date then G4 is blank (irrespective of the fact that G4 has a formula in it) and if H4 is blank (but has a formula in the cell) then G4..

=IF(H4="",IF(ISNA(VLOOKUP($A4,'Data Entry'!$B$6:$EA$863,75,0)),"",(VLOOKUP($A4,'Data Entry'!$B$6:$EA$863,75,0))),IF(H4<>"","",IF(ISNA(VLOOKUP($A4,'Data Entry'!$B$6:$EA$863,75,0)),"",(VLOOKUP($A4,'Data Entry'!$B$6:$EA$863,75,0)))))

tricky if formula

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.