Quote Originally Posted by wmorris View Post
I do have a question if this is possible.....

My warehouse DB uses the Excel or CSV format.

I tie my Excel DB with my Warehouse Excel DB.

I am using the =vlookup command when I use the product number and quantity from the warehouse excel DB and when I use my Excel DB some of my quantities says "N/A" when means either my warehouse doesn't carry that product anymore. When I upload the updated excel to to the it shows those products shows (0) quantities. Is it possible that the N/A can be automatically deleted from the database without me delete it from the database manually?
Could you please clarify? When I first read the message I thought the request was to possibly delete the product from the database, but now it seems like may be asking to delete the text 'N/A' from the product's quantity.

If it is the deletion of 'N/A' I would say that the "better" option is to further use the formulas to detect if the value is N/A and use 0 when it is. The function ISNA supports that.