| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i replace #n/a in a vlookup?
Can you please show me how to replace the #N/A result with 0?
=VLOOKUP(L2,'March Chargebacks'!A$1:F$613,6,FALSE) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replace VLOOKUP results with data | Excel Worksheet Functions | |||
| Replace a vlookup #N/A result with a value | Excel Worksheet Functions | |||
| Replace Vlookup with a macro | Excel Discussion (Misc queries) | |||
| How do I replace a return value of #N/A in a vlookup with zero? | Excel Worksheet Functions | |||
| When VLOOKUP returns a #N/A How can you get it to replace #N/A wi. | Excel Worksheet Functions | |||
Threaded Mode
