Hi Experts excel 2007
I have the following of formula in cell b2
If (A2="", if (c2="","", c2), VLOOKUP (a2,'sheet2'! $ a $2:$b $20,2, False))
Which is fine...I need to add the following step...if g2 date is less then todays date then replace c2 with complete, if g2 has no date then above formula.