Saturday 14 March 2015

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

No comments:

Post a Comment

Popular Posts