Vlookup Replace "N/A"

With a vlookup command in Excel, you often get "N/A"s if nothing is found. These can look quite ugly.

If you want to replace them with something, you can of course copy and paste the text so that the formulas are no more. Then do a find and replace. But that means the formulas are gone and the spreadsheet is no longer dynamic i.e. it won't change as the data changes.

Better instead to use a formula, I found a good solution here:

Quick replace #N/A by 0 when vlookup