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?