| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 Solver Internal Error When Generating Answer Report | Excel Discussion (Misc queries) | |||
| HELP..... Pivot report error | Excel Discussion (Misc queries) | |||
| Excel opens with an error report whenever I Boot Up my computer | Excel Discussion (Misc queries) | |||
| "Unable to read file" error message when opening a Excel file that contains a PivotTable report. | Charts and Charting in Excel | |||
| Error report closing excel | Excel Discussion (Misc queries) | |||
![Don Murray[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
