Software

Ask something
Discussion Locked

Relative ref in Excel Intersection

0 helpful
3 replies

by tedbruning

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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!

3 replies

by dklippert

I can use Indirect, if I define the ranges rather than try to use labels.
{=(INDIRECT(A1) INDIRECT(B1))*10}

This discussion is closed to new replies.