Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula
I'm trying to do a projection for A/P with a data sheet that has all open
invoices (Vendor, Due Date and Trx Amount), then I have another sheet has Vendor, amount by current, 31-60, 61-90, and 91+ that list each week for several months after that. What I need to do Is compare Column A(Vendor) in both sheets by Vendor because the data sheet will be different when I run the smart list by new invoices that are added and then by due dates so that it returns the $ amount for each invoice in the appropriate column by due date. I'm also going to need to do a <= and/or = to capture all due dates. For instance my first date is 5/9/07 I will need to capture 5/9/07 and anything less then that date. Also my next date 5/16/07 so I will need to capture anything greater than 5/9/07, but less than 5/16/07. Do I need to do a Vlookup and then an If statement? I've been playing around with it and just can't seem to get it to work. Thanks -- Chris Jones |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
match formula - 2 excel files:#1 hasthis formula, 2nd has the Raw | Excel Worksheet Functions | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
How do I view formula results intead of formula in excel? | Excel Worksheet Functions | |||
i edit a formula (excel) then it displays formula not answer | Excel Discussion (Misc queries) |