In B2 Sheet 2 try the following
=IF(AND(Sheet2!$F$2<A2),Sheet1!A2," ")
drag to the right for Inv No , Date, Value, Job No.
edvwvw
Peter wrote:
Hi,
I am looking for any kind of function that will enable the following:-
Sheet 1
Col A Col B Col C Col D Col E Col F
Name Inv No Date Value Job No Payment due Date
XYZ 1234 1/2/08 £1500 1000 4/7/08
Sheet 2
Col A Col B Col C Col D Col E Col F
04/07/2008 Name Invoice No Date Value Job No
XYZ 1234 1/2/08 £1500 1000
Formula to show - if date on sheet 1 is less than or equal to date on sheet
2 then show data in respective fields on sheet 2.
I have tried =if(sheet 1!F2<=sheet 2!a1,sheet 1!A2:a50,"") but returns #Value.
Any suggestions
--
Message posted via
http://www.officekb.com