How can I get excel not to report n/a error when using index?

D

Don Murray

=INDEX($X$4:$Y$26,MATCH(C6,X4:X26,),MATCH("Mon",X4:Y4,))

If I enter a number in C6 that is not in my list, I get a n/a error, I know
why I get this but is there any way to have something else there besides the
N/A?
 
M

Max

Try trapping it with an IF(ISNA(...) construct, viz.:
=IF(ISNA(MATCH(C6,X4:X26,)),"",INDEX(...))
Change the "" result to suit
 

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

#N/A error?? 3
Index Match Problem 3
Index Match Concatenate 8
Missing data when using TREND function 0
Varied Results obtained using Index and Match in Excel 2003 and 2007 0
How can I automatically replace the error #N/A with 0 in Excel? 3
INDEX MATCH #N/A Error 3
Extracting Terms and Exponents of a Text Poly Formula ?? 4

Top