| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
match formula - 2 excel files:#1 hasthis formula, 2nd has the Raw
I have a match formula that shows correct data from a second exel file but
when I close the second excel file the file with this formula replaces the correct data to show #value. How can I chg the formula to not require the second file to be one inorder to have the correct data? OFFSET('U:\Department\General Accounting\Budget\2007\Data Files\[2007 Depreciation.xls]Software Amort'!$B$3,MATCH($A$1,'U:\Department\General Accounting\Budget\2007\Data Files\[2007 Depreciation.xls]Software Amort'!$A$3:$A$46,FALSE)-1,MATCH(V$6,'U:\Department\General Accounting\Budget\2007\Data Files\[2007 Depreciation.xls]Software Amort'!$B$1:$M$1,FALSE)-1) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel formula Q | Excel Worksheet Functions | |||
| Trouble writing an excel formula. | Excel Worksheet Functions | |||
| Recurring Excel Formula error - multiple users affected! | Excel Discussion (Misc queries) | |||
| converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
| How do I view the actual numeric value of a formula in Excel 2002. | Excel Worksheet Functions | |||
Threaded Mode
