Is there any way to replace #N/A with
zero(s)? I tried using find/replace under edit (doesn't work)..... The #N/A are present because Vlookup didn't find matching numbers.... Basically, what I want to do is whenever Vlookup doesn't find a value I want zero to be entered into that cell.....
Any help would be greatly appreciated...
Thanks Caleb Shanafelt...
zero(s)? I tried using find/replace under edit (doesn't work)..... The #N/A are present because Vlookup didn't find matching numbers.... Basically, what I want to do is whenever Vlookup doesn't find a value I want zero to be entered into that cell.....
Any help would be greatly appreciated...
Thanks Caleb Shanafelt...