| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Vlookup wheb value missing
Use:
C1 <lookup value A1:B20 <lookup table =IF(ISERROR(VLOOKUP(C1,A1:B20,2,FALSE)),0,VLOOKUP( C1,A1:B20,2,FALSE)) HTH "nir020" wrote: How can you when using vlookup return a value of 0 rather than #N/A when the lookup value is not present in the table array? Thanks Nick |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup returns n/a for all lines - what am I missing? | Excel Worksheet Functions | |||
| VLOOKUP - recover missing data source | Excel Worksheet Functions | |||
| Charting with missing data or empty strings from vlookup() | Charts and Charting in Excel | |||
| vlookup missing link | Excel Discussion (Misc queries) | |||
| VLOOKUP and Missing Values | Excel Programming | |||
Threaded Mode
