CiaoKarina
New Member
- Joined
- Oct 22, 2021
- Messages
- 12
- Office Version
- 365
- Platform
- MacOS
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")"
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")"