Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    102

    Unanswered: Combing Relative and Direct Referencing

    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

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Quote Originally Posted by ontheDB
    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 ?
    No, once you go to R1C1 notation, then the whole thing has to be the same R1C1 format.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    you could reference the cells directly i.e.

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

    This should do the job you want

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •