Using Calc, I have a cell on one sheet that pulls its string contents from a different sheet. For illustration:
- Sheet One in A1 has
- Other Sheet in D2 has “My string”.
On yet a third sheet, I want to know what column is being referenced in
$'sheet one'.A1 – that is, whatever formula/function is used, the third sheet should get the value: D.
Question: How to extract that “D” value from “Sheet One” on “Sheet Three”??
(When I’ve made an attempt using
MID() plus a “soft” cell reference, it just treats the cross reference as the string: it doesn’t analyse the “returned” value in that cell.)