Excel VLOOKUP #N/A Suppression
One of the problems when using a basic VLOOKUP query in Excel is that Excel will return an '#N/A' error if it cannot find a value.
It can look untidy in a spreadsheet and you may prefer that the value returned should be a blank or a zero if there is no match.
This error message can be supressed in a formula by combining the VLOOKUP formula with the ISNA function, but it can be a little tricky to compose.
Below is a tool that automates the process of adapting a single VLOOKUP/HLOOKUP formula to add the ISNA function to return a blank or zero value instead.
To use the tool, paste in a single VLOOKUP or HLOOKUP formula into the textbox and
click the 'Submit' button to add the extra code.
For example, paste in: =VLOOKUP(H8,Sheet2!A1:B3,2,FALSE)