Vlookup If Na Then 0. If you want to return blank instead of 0 or n a error you can use a formula based on the iferror function the if function the len function and the vlookup function. However when the result in a lookup table is an empty cell no error is thrown vlookup simply returns a zero.
Excel Formula Vlookup Without N A Error Exceljet from exceljet.net
If vlookup e1 a 2 b 10 2 false 0 no yes instead of yes no you can return true false or in stock sold out or any other two choices. In this case be sure to enclose a text string in quotation marks like this. Then all n a errors will be replaced with 0.
Select a range where you want to replace the n a errors with 0 and click kutools more error condition wizard.
If vlookup e1 a 2 b 10 2 false 0 no yes instead of yes no you can return true false or in stock sold out or any other two choices. If you want to return a specific text instead of the 0 value you can apply this formula. You can use the ifna function or iferror function to trap this error. If len vlookup d2 a2 b10 2 0 0 specific text vlookup d2 a2 b10 2 0.
