General discussion
-
Topic
-
Relative ref in Excel Intersection
LockedHow 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 660Change formula in A4 to: =(A1 B1)*10
Given, cell A1=”rValB” and cell B1=”cValB”
Yields answer of #NULL!