Is it possible to combine both relative and direct referencing in a formula ?

for example, i am trying to do:

ActiveCell.FormulaR1C1 = _
"=VLOOKUP(RC[-1],$H$1:$K$10,2,False)"


the first value (RC[-1]) is relative, but the second ($H$1:$K$10) is not.
This is giving me an error
How else can i do this ?

thanks,
C

No, once you go to R1C1 notation, then the whole thing has to be the same R1C1 format.

you could reference the cells directly i.e.

=VLOOKUP(RC[-1],R1C8:R10C11,1,FALSE)

This should do the job you want