Excel 2003 index function does not calculate
 

Hello,

I am using the following index formula, but it will not calculate. I have
verified that my options for "Calulate" are set to automatic. Does nayone
know what the problem might be?

=INDEX([EGYPTF.xls]EGYPTF!$DE$2:$DE$363,MATCH(F1,[EGYPTF.xls]EGYPTF!$AJ$2:$AJ$363,0))

Thanks,

Excel 2003 index function does not calculate
 

Hi,

What version of Excel are you using? Are you using any user defined
functions?

I found the following in a Google groups search on "excel formulas do not
calculate":

http://groups.google.com.au/group/mi...7fee234aa2f9bf

http://groups.google.com.au/group/mi...7fee234aa2f9bf

http://groups.google.com.au/group/mi...a5c1e56b899e4a

Hope this helps.

Sean

"Lost in Alabama" wrote in message
...
Hello,

I am using the following index formula, but it will not calculate. I have
verified that my options for "Calulate" are set to automatic. Does nayone
know what the problem might be?

=INDEX([EGYPTF.xls]EGYPTF!$DE$2:$DE$363,MATCH(F1,[EGYPTF.xls]EGYPTF!$AJ$2:$AJ$363,0))

Thanks,

Excel 2003 index function does not calculate
 

Sean,

Thank you for the information. I keep forgetting about the Google info.

Lost

"Sean" wrote:

Hi,

What version of Excel are you using? Are you using any user defined
functions?

I found the following in a Google groups search on "excel formulas do not
calculate":

http://groups.google.com.au/group/mi...7fee234aa2f9bf

http://groups.google.com.au/group/mi...7fee234aa2f9bf

http://groups.google.com.au/group/mi...a5c1e56b899e4a

Hope this helps.

Sean

"Lost in Alabama" wrote in message
...
Hello,

I am using the following index formula, but it will not calculate. I have
verified that my options for "Calulate" are set to automatic. Does nayone
know what the problem might be?

=INDEX([EGYPTF.xls]EGYPTF!$DE$2:$DE$363,MATCH(F1,[EGYPTF.xls]EGYPTF!$AJ$2:$AJ$363,0))

Thanks,