General discussion

Locked

Relative ref in Excel Intersection

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!

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Relative ref in Excel Intersection

by DKlippert In reply to Relative ref in Excel Int ...

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

Collapse -

Relative ref in Excel Intersection

by Shanghai Sam In reply to Relative ref in Excel Int ...

Doug, that was the solution.
Seasons Greetings and Thanks,
Ted

Collapse -

Relative ref in Excel Intersection

by tedbruning In reply to Relative ref in Excel Int ...

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums