Excel 2003 index function does not calculate

L

Lost in Alabama

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,
 
L

Lost in Alabama

Sean,

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

Lost

Sean said:
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/m...o+not+calculate&rnum=4&hl=en#527fee234aa2f9bf

http://groups.google.com.au/group/m...o+not+calculate&rnum=4&hl=en#527fee234aa2f9bf

http://groups.google.com.au/group/m...o+not+calculate&rnum=5&hl=en#60a5c1e56b899e4a

Hope this helps.

Sean

Lost in Alabama said:
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,
Click to expand...
Click to expand...
 
Top