Join or sign in Register for your free TechRepublic membership or if you are already a member, sign in using your preferred method below. Use Your Email Use FacebookUse Linkedin

Relative ref in Excel Intersection

Locked

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!

Topic

Relative ref in Excel Intersection

In reply to Relative ref in Excel Intersection

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

Relative ref in Excel Intersection

In reply to Relative ref in Excel Intersection

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

Relative ref in Excel Intersection

In reply to Relative ref in Excel Intersection

This question was closed by the author

[Author]

Replies