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?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
