| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
INDEX/MATCH update limitation
I was very happy when I found the INDEX/MATCH formula. However, as MATCH and
VLOOKUP formulas seem to be able to udate themselves, even though the source document is closed...INDEX/MATCH formulas seem not be able to update when the source document is closed. I am using Microsoft Excel 2003. Am i doing something wrong, or is it simply impossible? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
INDEX/MATCH update limitation
Hi,
The problem is with INDEX - in Excel it doesn't work with external files that are closed. It works with closed files in Lotus 1-2-3 even back in 1982. And in Open Office today. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "mariekek5" wrote: I was very happy when I found the INDEX/MATCH formula. However, as MATCH and VLOOKUP formulas seem to be able to udate themselves, even though the source document is closed...INDEX/MATCH formulas seem not be able to update when the source document is closed. I am using Microsoft Excel 2003. Am i doing something wrong, or is it simply impossible? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
INDEX/MATCH update limitation
The problem is with INDEX - in Excel it doesn't
work with external files that are closed. Sure it does. =INDEX('C:\TV\[X.xls]Sheet1'!$D:$D,MATCH("junk",'C:\TV\[X.xls]Sheet1'!$C:$C,0)) Works just fine when the file X.xls is closed. -- Biff Microsoft Excel MVP "Shane Devenshire" wrote in message ... Hi, The problem is with INDEX - in Excel it doesn't work with external files that are closed. It works with closed files in Lotus 1-2-3 even back in 1982. And in Open Office today. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "mariekek5" wrote: I was very happy when I found the INDEX/MATCH formula. However, as MATCH and VLOOKUP formulas seem to be able to udate themselves, even though the source document is closed...INDEX/MATCH formulas seem not be able to update when the source document is closed. I am using Microsoft Excel 2003. Am i doing something wrong, or is it simply impossible? |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
INDEX/MATCH update limitation
Oops, read too fast, thought we were talking about INDIRECT. My comments
apply to INDIRECT, not INDEX. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "T. Valko" wrote: The problem is with INDEX - in Excel it doesn't work with external files that are closed. Sure it does. =INDEX('C:\TV\[X.xls]Sheet1'!$D:$D,MATCH("junk",'C:\TV\[X.xls]Sheet1'!$C:$C,0)) Works just fine when the file X.xls is closed. -- Biff Microsoft Excel MVP "Shane Devenshire" wrote in message ... Hi, The problem is with INDEX - in Excel it doesn't work with external files that are closed. It works with closed files in Lotus 1-2-3 even back in 1982. And in Open Office today. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "mariekek5" wrote: I was very happy when I found the INDEX/MATCH formula. However, as MATCH and VLOOKUP formulas seem to be able to udate themselves, even though the source document is closed...INDEX/MATCH formulas seem not be able to update when the source document is closed. I am using Microsoft Excel 2003. Am i doing something wrong, or is it simply impossible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Index/Match Cell Limitation? | Excel Discussion (Misc queries) | |||
| index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
| limitation to Match formula? | Excel Discussion (Misc queries) | |||
| MATCH Limitation? | Excel Worksheet Functions | |||
| Offset, indirect, match function limitation on linked worksheets. | Excel Worksheet Functions | |||
Hybrid Mode
