VBA code for Cell Value that Includes IfError

[nau2002]

Hello, I have a VBA change event that inserts a v-lookup as follows:

cell.Value = "=VLOOKUP(""C""&(TEXT(RC[-1],""0"")),'Summary by Project- exBR'!R4C3:R200C4,2,FALSE)"

I need the formula to be modified to include an iferror function (or something similar), so that if the value is #NA , it will return a blank result, "".

Any thoughts?

 

[mrshl9898]

"=IFERROR(VLOOKUP(""C""&(TEXT(RC[-1],""0"")),'Summary by Project- exBR'!R4C3:R200C4,2,FALSE),"")"

 

[nau2002]

Thanks for the suggestion. I'm receiving an error when I use that code: Run-Time Error 1004 Application-defined or object-defined error.
When I try debug, it highlights the line with that formula as the error. Any other thoughts?

 

[L. Howard]

Try the double/double quote, as shown in red

"=IFERROR(VLOOKUP(""C""&(TEXT(RC[-1],""0"")),'Summary by Project- exBR'!R4C3:R200C4,2,FALSE),"""")"

Howard

 

[nau2002]

Yes, works - thanks!