Thread: #NA error on a INDEX formular
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
PAS PAS is offline
external usenet poster
  
Posts: 26
Default #NA error on a INDEX formular
Does anybody know why I am getting #NA with this formula. It was working OK
awhile ago????

=INDEX($B$2:$BJ$402,MATCH(B411,$A$2:$A$402,0),MATC H(B410,$B$1:$BJ$1,0))
Reply With QuoteReply With Quote