ActiveCell.FormulaR1C1 =
"=IF(COUNTIF([ITEM.XLS]SHEET1!C[-11],RC[-6]),VLOOKUP(RC[-6],[ITEM.XLS]SHEET1!C[-11]:C[-1],11,0),0)"

How I can give the varibale for RC[-6] in the above formula. Because it
might not be the column before 6 in all the time. For example if I insert a
new column and that forumula should be worked out from the new column . So
please help to rewrite the forumula to workout from any column

With thanks
Pol