| 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? |
| 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)
Threaded Mode
