Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup or #N/A
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup or #N/A
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |