I use this formula in my macro:


ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[9],ref1,2,FALSE)"

Is it possible to add code that will do the lookup in "ref1" and "ref2" ?

Thank you in advance.