Hello all. This is my first post here after much searching on the internet. I have a fairly large sheet I am working on which currently has several hundred formulas. I am using Office7. A fairly large number of the formulas use the Vlookup function and I am getting #N/A errors returned which is causing me grief. What I need is to have it return a zero length string which Excel will not have a problem with. I can do this if I wrap the Vlookup function within an Iferror function. The only way I know to make a mass change is to use edit/replace (Ctl-H) but unfortunately, I need to do the fix in two passes. First pass replaces VLOOKUP with IFERROR(VLOOKUP and the second pass replaces FALSE) with FALSE),"") but Excel will not let me do the first pass because it is an invalid function at that point. If I could do both passes, it will be a valid entry but it doesn't know that I know what I am doing so it will not let me do it. If I can't do this, I will be forced to re-enter at least a hundred formulas. Does anyone know another way?

Maybe it would be advisable to be able to access the error values easily for the future. You could use conditional formatting to make error messages the same colour as the background. It would then be easy to review them just by changing the formatting to a visible colour if needed.
For example if your formula does not return a value just because of an invisible space or so, you could loose valuable information

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post