Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup / Match function
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup / Match function
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup / Match function
I must have been asleep when I looked at this - the correct formula is:
'=IF(AND(Sheet2!$A$2Sheet1!$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.a...excel/200807/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup / Index / Match Function | Excel Discussion (Misc queries) | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
Double and Multiple Lookup Using the MATCH Function | Excel Worksheet Functions | |||
Lookup Function and Match | Excel Discussion (Misc queries) |