IF or vlookup formula
This has worked fine, but is their any way i can just have the values where
this argument is applicable instead of 0 when it doesn't
"Jacob Skaria" wrote:
In cell A1 and copy down as required
=IF(AND(B1DATE(2008,12,31),B1<DATE(2010,1,1)),A1, 0)
If this post helps click Yes
---------------
Jacob Skaria
"Rob" wrote:
I am trying to return the values of column Ain column C if the dates in
column B are between 31/12/2008 and 01/01/2010
Column A Column B Column C
1040 24/12/2008 1042
1042 03/01/2009 1041
1041 21/06/2009 1043
1043 21/12/2009
1045 03/01/2010
Have tried =IF(AND(B:B31/12/2008,B:B<01/01/2010),A:A,0)
|