| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
would like to substitute and return value of 0 for vlookup #N/A er
I would like to return the value of 0 when the vlookup would otherwise return
the error #N/A - any suggestions? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
would like to substitute and return value of 0 for vlookup #N/A er
=IF(ISNA(VLOOKUP(......)),0,VLOOKUP(.......))
"egols" wrote: I would like to return the value of 0 when the vlookup would otherwise return the error #N/A - any suggestions? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
would like to substitute and return value of 0 for vlookup #N/A er
You could try this:
=IF(ISNA(VLOOKUP(...)),0,VLOOKUP(...)) Basically, if your VLOOKUP returns the N/A error, then a 0 will be displayed, otherwise, show the results of your VLOOKUP. HTH, Elkar "egols" wrote: I would like to return the value of 0 when the vlookup would otherwise return the error #N/A - any suggestions? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
would like to substitute and return value of 0 for vlookup #N/A er
I am not quite sure how to reply - but these postings did exactly what I
needed - thanks. "egols" wrote: I would like to return the value of 0 when the vlookup would otherwise return the error #N/A - any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP - WISH TO SUBSTITUTE FALSE FOR A VALUE | Excel Discussion (Misc queries) | |||
| VLOOKUP to return first hit | Excel Worksheet Functions | |||
| How do I return the row for a value I VLOOKUP? | Excel Worksheet Functions | |||
| VlookUp that does not return #N/A | Excel Worksheet Functions | |||
| Is there a VLOOKUP substitute when data is not in ascending order | Excel Worksheet Functions | |||
Hybrid Mode
