<div>
Stop in .....5 star feedback.
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts excel 2007<br />
<br />
I have the following if formula<br />
=IF(OR(G2=&quot;&quot;,G2&lt;TODAY()),A<wbr />A2,IF(A2=&quot;<wbr />&quot;,IF(C2=&quot;&quot;<wbr />,&quot;&quot;,C2),VL<wbr />OOKUP(A2,s<wbr />heet2!$A$2<wbr />:$B$20,2,F<wbr />ALSE)))<br />
<br />
which need amending to do the if g2 is blank then c2, if g2 has a date less then todays date as above then the above formula..
</div>
</div>


Hi Experts excel 2007

I have the following if formula
=IF(OR(G2="",G2<TODAY()),AA2,IF(A2="",IF(C2="","",C2),VLOOKUP(A2,sheet2!$A$2:$B$20,2,FALSE)))

which need amending to do the if g2 is blank then c2, if g2 has a date less then todays date as above then the above formula..

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.