I use a vlookup function to pull out a number from a column of numbers based on certain conditions. If the result is a number it will give me the number ok. If it cannot meet the condition it gives me a "n/a". That works as it should. However I now want to convert the "n/a" to a zero so I can add the column. How can I do this?