Prev: Restricted Access with Macros
Next: Excel 2003 Comments
From: Peter on 4 Jul 2008 06:23
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





From: edvwvw via OfficeKB.com on 4 Jul 2008 09:15
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

From: edvwvw via OfficeKB.com on 4 Jul 2008 09:25
I must have been asleep when I looked at this - the correct formula is:

'=IF(AND(Sheet2!$A$2>Sheet1!$H$2),Sheet1!A2," ")

edvwvw

edvwvw wrote:
>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
>
>>Hi,
>>
>[quoted text clipped - 16 lines]
>>
>>Any suggestions

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/ms-excel/200807/1

 | 
Pages: 1
Prev: Restricted Access with Macros
Next: Excel 2003 Comments