| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
replacing #N/A with 0
In Excell 2003 how would I write this formula to replace the #N/A with 0? Can
it be done? =VLOOKUP(A5,Group!$C$1251:$H$1287,6,0) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding and Replacing a "?" | Excel Discussion (Misc queries) | |||
| replacing TRUE/FALSE | New Users to Excel | |||
| replacing TRUE/FALSE | New Users to Excel | |||
| replacing just the sheet names within formulas | Excel Worksheet Functions | |||
| Replacing a number with a description in Excel | Excel Worksheet Functions | |||
Threaded Mode
