Use Integer in FormulaR1C1 vlookup?

Hi all, i’m trying to combine an Integer which denotes a column number with an ActiveCell.FormulaR1C1 command as follows - is this possible? Currently it doesn’t work but i’d like to know if there is a way of making it happen!

ActiveCell.FormulaR1C1 = “=IFERROR(VLOOKUP(RC[(-xcol+4)],aaa,5,false),0)”

where xcol is a defined Integer, the value being defined a few lines earlier and in this case being 117. The idea is to offset from column a by a set number of columns to locate the current-week column then insert a vlookup formula where the lookup variable is located in column E.

Thanks in advance for any tips!

Thanks for your suggestion - sadly it hasn’t had the desired effect. The cells in question all contain zero, and there’s no formula added.

Thanks rorya - this has solved it!