General discussion

  • Creator
    Topic
  • #2131090

    Relative ref in Excel Intersection

    Locked

    by tedbruning ·

    How do I convert relative cell references to literals for an Intersection Operator?
    Ex. Sheet:
    ——-A—-|—-B—-|—–C—–|—–D—–|—–E—–
    1_rValB_|______|_______|_cValA_|_cValB_
    2_cValB_|______|_rValA_|__33___|__44___
    3_______|______|_rValB_|__55___|__66___
    4_______|______|_______|_______|_______

    C2:E3 is a range
    D1:E3 is a range
    Formula in A4: =(rValB cValB)*10
    Yields answer of 660

    Change formula in A4 to: =(A1 B1)*10
    Given, cell A1=”rValB” and cell B1=”cValB”
    Yields answer of #NULL!

All Comments

Viewing 1 reply thread