Is it possible to get a range that is calculated from a formula? For example...
where C8 = A43:A
C8 uses the following formula, ="A"&C6&":A"
A43 is being calculated using a Match function which resides in cell C6google-spreadsheetspreadsheet