Thread: Excel 2003 index function does not calculate
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lost in Alabama
 
Posts: n/a
Default 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,


Reply With QuoteReply With Quote