ExcelBanter - vlookup or #N/A

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - vlookup or #N/A (https://www.excelbanter.com/excel-worksheet-functions/94434-vlookup-n.html)

I have designed a sales tracking worksheet which I assigned a specific
numbers to distributors. In an other sheet I copy the sale and vlookup
function just look up the data and display on specific cells. But the problem
is that if any distributor have no sale on particular date. Cell displayed
the error message "#N/A". This means that I first to delete all cells value
which contains that error and then I able to see the total sales.
I used this function with if command to prevent this error but in vain.
Anybody please help me to overcome this situation.

Try an IF(ISNA(...), .. error trap, set to return a zero* if TRUE
Eg, something like: =IF(ISNA(VLOOKUP(...)),0,VLOOKUP(...))

*so that downstream calcs can proceed unaffected
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Tarique" wrote:
I have designed a sales tracking worksheet which I assigned a specific
numbers to distributors. In an other sheet I copy the sale and vlookup
function just look up the data and display on specific cells. But the problem
is that if any distributor have no sale on particular date. Cell displayed
the error message "#N/A". This means that I first to delete all cells value
which contains that error and then I able to see the total sales.
I used this function with if command to prevent this error but in vain.
Anybody please help me to overcome this situation.