| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Offset/match returns #value error
The following function looks up a value in another workbook:
=OFFSET('PATH\Testing\2008hi\[0208hi.xls]WKSHT_NAME'!$C$8,MATCH($A11,'PATH\Testing\2008hi\[0208hi.xls]WKSHT_NAME'!$A$9:$A$96,0)+4,0) Unfortunately when that particular workbook is closed, the function returns a #VALUE! error - so the referenced spreadsheet needs to be open for the formula to be evaluated. I could replace all the formulae with values but I would like to preserve the reference to the other spreadsheet in the cells if at all possible. Any suggestions? -- There are 10 types of people in the world - those who understand binary and those who don't. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Offset/Match formula returns "#N/A" | Excel Discussion (Misc queries) | |||
| OFFSET: Returns error when used to a linked file | Excel Worksheet Functions | |||
| Array Offset() formula with height of 1 returns duplicates? | Excel Worksheet Functions | |||
| MATCH and OFFSET | Excel Worksheet Functions | |||
| Offset() returns reference, first not value (proof) | Excel Discussion (Misc queries) | |||
Threaded Mode
