Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

calc - function to define cellrange

INDIRECT(prefix & "0" & suffix & "." & myROWA & ":" & myROWA)~INDIRECT(prefix & "1" & suffix & "." & myROWA & ":" & myROWA)~INDIRECT(prefix & "2" & suffix & "." & myROWA & ":" & myROWA)

where

prefix: mySheet_
suffix: _A
myROWA: B

are stored in named cells on a sheet

Can I somehow turn this into a "lambda function"?

e.g. let's say myROWA is stored in $E$11 what I want is

data3(E11)

which desugars into

INDIRECT(prefix & "0" & suffix & "." & B & ":" & B)~INDIRECT(prefix & "1" & suffix & "." & B & ":" & B)~INDIRECT(prefix & "2" & suffix & "." & B & ":" & B)

(because E11 stores B)

now if E12 stores F, then data3(E12) should desugar into

INDIRECT(prefix & "0" & suffix & "." & F & ":" & F)~INDIRECT(prefix & "1" & suffix & "." & F & ":" & F)~INDIRECT(prefix & "2" & suffix & "." & F & ":" & F)