| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
error message handling #N/A
Hi,
Could any kind soul out there tell me how I would add ISERROR to the following to stop #N/A? '=INDEX(Sheet1!$A$7:$A$1152,MATCH($C79,Sheet1!$C$7 :$C$1152,0)) Cheers -- Mifty |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
error message handling #N/A
Try this
=IF(ISNA(INDEX(Sheet1!$A$7:$A$1152,MATCH($C79,Shee t1!$C$7:$C$1152,0))),"",INDEX(Sheet1!$A$7:$A$1152, MATCH($C1,Sheet1!$C$7:$C$1152,0))) Mike "Mifty" wrote: Hi, Could any kind soul out there tell me how I would add ISERROR to the following to stop #N/A? '=INDEX(Sheet1!$A$7:$A$1152,MATCH($C79,Sheet1!$C$7 :$C$1152,0)) Cheers -- Mifty |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
error message handling #N/A
Mike,
Forgot to say 'Yes works beautifully' Many thanks -- Mifty "Mike H" wrote: Try this =IF(ISNA(INDEX(Sheet1!$A$7:$A$1152,MATCH($C79,Shee t1!$C$7:$C$1152,0))),"",INDEX(Sheet1!$A$7:$A$1152, MATCH($C1,Sheet1!$C$7:$C$1152,0))) Mike "Mifty" wrote: Hi, Could any kind soul out there tell me how I would add ISERROR to the following to stop #N/A? '=INDEX(Sheet1!$A$7:$A$1152,MATCH($C79,Sheet1!$C$7 :$C$1152,0)) Cheers -- Mifty |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| error handling-need to get rid of a value returned as #N/A | Excel Worksheet Functions | |||
| Error Handling for xlCellTypeFormulas | Excel Worksheet Functions | |||
| Error Handling works only once | Excel Discussion (Misc queries) | |||
| Handling #NUM! error | Excel Worksheet Functions | |||
| Error handling in a search | Excel Discussion (Misc queries) | |||
Hybrid Mode
