| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I remove the #div or N/A and make it 0 when using VLookup?
I have a very large worksheet that I am using the following vlook up on
=IF(ISNA(VLOOKUP(trim($D5),Dataentry!$D$9:$P$1508, 12,0)),0,VLOOKUP(trim($D5),Dataentry!$D$9:$P$1508, 12,0)) I am using the results of the lookup for another calculation, so I don't want the return value from my look up to be N/A. Can you please tell me how to make it 0 instead of the N/A when there is no match in the lookup sheet. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you make a cell with a diagonal, so that you can edit the upper and lower part of the cell? | New Users to Excel | |||
| make hidden window or workbook visible without specify the name | Excel Worksheet Functions | |||
| make a cell empty based on condition | Charts and Charting in Excel | |||
| make cell contents equal to null value - not blank, but empty | Excel Worksheet Functions | |||
| How to make this plot? | Charts and Charting in Excel | |||
Threaded Mode
