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?