#NA error on a INDEX formular

P

Pas

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),MATCH(B410,$B$1:$BJ$1,0))
 
D

Dave Peterson

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, ...).
 
P

Pas

Yes the second formula results in #NA. I have a textbox linked to cell "B410"
, which has a formula. When I clear the formula on that cell it works fine.
For some weird reason it's giving #NA because the fact that the cell has a
formula???
Any ideas?
 
D

Dave Peterson

Nope.

It's giving you the error because the value in that textbox doesn't match any of
the cells in B1:BJ1.

==
Are the values you're matching on digits?

If yes, then try:
=MATCH(--B410,$B$1:$BJ$1,0)

The -- stuff will coerce any text number to a real number. The first minus
converts the text number to a number (but the opposite sign). The second
changes the sign back but keeps the number.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top