#NA error on a INDEX formular
Cheers Dave, I'll try that and let you know how I get on.
"Dave Peterson" wrote:
Put these portions of your formula in two other cells:
=MATCH(B411,$A$2:$A$402,0)
=MATCH(B410,$B$1:$BJ$1,0)
One or both will return that #N/A error. You'll have to find out why there's a
mismatch (spelling error, too many spaces, ...).
Pas wrote:
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))
--
Dave Peterson
.
|