| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Is there any easier way to do this formula?
I am using the following formula in a worksheet, it works perfectly, however,
it is so long that it hides the first 8 or 9 lines of my spreadsheet when I click on the cell containing it. Is there a shorter way to do the same thing? =INDEX('[Weekly Sales by Department 2005.xls]PRODUCE'!$N$6:$N$428,MATCH(B2&C2,'[Weekly Sales by Department 2005.xls]PRODUCE'!$C$6:$C$429&'[Weekly Sales by Department 2005.xls]PRODUCE'!$B$6:$B$429,0))+INDEX('[Weekly Sales by Department 2005.xls]PRODUCE'!$N$6:$N$428,MATCH(B2&D2,'[Weekly Sales by Department 2005.xls]PRODUCE'!$C$6:$C$429&'[Weekly Sales by Department 2005.xls]PRODUCE'!$B$6:$B$429,0))+INDEX('[Weekly Sales by Department 2005.xls]PRODUCE'!$N$6:$N$428,MATCH(B2&E2,'[Weekly Sales by Department 2005.xls]PRODUCE'!$C$6:$C$429&'[Weekly Sales by Department 2005.xls]PRODUCE'!$B$6:$B$429,0)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change formula for Employee Shift Schedule template | Excel Worksheet Functions | |||
| writing a formula for a colored value | New Users to Excel | |||
| adding row to forumla | Excel Discussion (Misc queries) | |||
| Need a formula that would make life easier | Excel Worksheet Functions | |||
| Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Threaded Mode
