| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to replace #N/A with my Vlookup
Cant seem to work this out, can you please show me how to replace the #N/A with a blank if the value searched is not found
=VLOOKUP(D2,Q2:W47,6, False) many thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i replace #n/a in a vlookup? | Excel Worksheet Functions | |||
| replace vlookup | Excel Programming | |||
| Replace a vlookup #N/A result with a value | Excel Worksheet Functions | |||
| 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
