| 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? |
| 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 | |||
Threaded Mode
