General discussion
Thread display: Collapse - |
All Comments
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Relative ref in Excel Intersection
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!