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

=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?

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

Try trapping it with an IF(ISNA(...) construct, viz.:
=IF(ISNA(MATCH(C6,X4:X26,)),"",INDEX(...))
Change the "" result to suit
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Don Murray" wrote:
=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?

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

Thank Max, You are fast, and it works great, thanks again.

Don Murray

"Max" wrote:

Try trapping it with an IF(ISNA(...) construct, viz.:
=IF(ISNA(MATCH(C6,X4:X26,)),"",INDEX(...))
Change the "" result to suit
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Don Murray" wrote:
=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?

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

Welcome, Don

Take a moment to press the "Yes" button
from where you're reading this
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Don Murray" wrote:
Thank Max, You are fast, and it works great, thanks again.

Don Murray