Greetings!

My issue is: I have a large spreadsheet that uses VLOOKUP to pull out data. But I have some #N/A results and I want to get rid of them by adding a IFERROR in front of the VLOOKUP so it becomes "=IFERROR(VLOOKUP(),0)". What I was trying to do is to substitute "IFERROR(VLOOKUP" for "VLOOKUP" using Find/Replace on all the functions and substitute the previous ending of the VLOOKUP with a ",0)" for the previous ending of the VLOOKUP. But it does not work as EXCEL tells me that IFERROR(VLOOKUP is an incomplete function. Is there a way to automate such modification to the function throughout the whole spreadsheet?

Thanks for your help!