Re: Replace VLOOKUP #N/A error with blank or zero
If you're at all technically inclined, or just get a kick out of figuring out how to simplify a complex or tedious/repetitious task, then I believe it would most definitely be worth your while to acquire some familiarity with VBA.
Particularly in Excel, it is a readily attainable skill, and you can start small and build from there. The macro recorder will capture the command syntax required for most actions you can carry out using the toolbars (or ribbons in 2007 and later). There are some excellent reference books available to help - for the complete novice, John Walkenbach's VBA Programming for Dummies series is quite good (with editions for each version of Excel).
Most important advice for starting out: while the macro recorder will show you commands using the "Select" method, when you go to write your own code, it is nearly always unnecessary. You can reference cells, sheets, workbooks, rows, columns etc. without having to select them. Another extremely useful trick to master early is assigning excel objects to variables, allowing you to operate on them without having to key long detailed names for them over and over.
Good luck! And know that you'll find lots of willing helpers in forums like this one.
Video Tutorials / Excel Dashboards Reports