IFNA with VLOOKUP format

[CiaoKarina]

Help! I have a VLOOKUP that is working perfectly until I try to address the #N/A.
The VLOOKUP references another workbook. When I recorded the macro it put " in front of the =(VLOOKUP....). What is this for? I think this is causing my problem.

Current macro:
Range("K1").Select
ActiveCell.FormulaR1C1 = _
"=(VLOOKUP(RC[-8],[VOLVOUPLOAD.xlsx]SHEET1!R3C[-10]:R100C[-5],6,0)"


Trying to change to include IFNA it won't accept it because it highlights the 2803F and says 'expecting end of statement'. If take out the " before the =IFNA and at the end, I don't get the VBA error message but it still does not address the N/A issue.

Range("K1").Select
ActiveCell.FormulaR1C1 = _
"=IFNA(VLOOKUP(RC[-8],[VOLVOUPLOAD.xlsx]SHEET1!R3C[-10]:R100C[-5],6,0),"2803F")"

 

[Fluff]

Hi & welcome to MrExcel.
You need to double up on the quotes inside the formula like

ActiveCell.FormulaR1C1 = _
       "=IFNA(VLOOKUP(RC[-8],[VOLVOUPLOAD.xlsx]SHEET1!R3C[-10]:R100C[-5],6,0),""2803F"")"

 

[CiaoKarina]

Thank you!!!!!! Worked like a charm.

 

[Fluff]

You're welcome & thanks for the feedback.