Yet another #N/A question

[jgarland]

I have tried for days to insert "ISERROR" OR "ISNA" into the following code in order to get rid of any #N/A errors but nothing I do works. Can anyone give me a clue as to how to do it?

The following line of VBA code inserts a VLOOKUP formula in a specific cell. It works perfectly but when there is no match I get the dreaded #N/A.

rngCell.Offset(0, -124).FormulaR1C1 = "=IF(RC[124]=""Y"",VLOOKUP(RC[3],'C:\Documents and Settings\Rgdjergar\Desktop\2 Autocorrect Database master.xls'!data1,2,FALSE),"""")"

 

[Comfy]

rngCell.Offset(0, -124).FormulaR1C1 = "=IF(ISNA(IF(RC[124]=""Y"",VLOOKUP(RC[3],'C:\Documents and Settings\Rgdjergar\Desktop\2 Autocorrect Database master.xls'!data1,2,FALSE),"""")),"",IF(RC[124]=""Y"",VLOOKUP(RC[3],'C:\Documents and Settings\Rgdjergar\Desktop\2 Autocorrect Database master.xls'!data1,2,FALSE),""""))"

 

[jgarland]

Thanks for the quick response but I get a Windows "Runtime error '1004' - Application-defined or object-defined error" on this line.

 

[jgarland]

Got it working. I added 2 additional quotation marks. See below

rngCell.Offset(0, -124).FormulaR1C1 = "=IF(ISNA(IF(RC[124]=""Y"",VLOOKUP(RC[3],'C:\Documents and Settings\Rgdjergar\Desktop\2 Autocorrect Database master.xls'!data1,2,FALSE),"""")),"""",IF(RC[124]=""Y"",VLOOKUP(RC[3],'C:\Documents and Settings\Rgdjergar\Desktop\2 Autocorrect Database master.xls'!data1,2,FALSE),""""))"

Thanks again for your help.