Is it possible to get a range that is calculated from a formula?

Pavel Pavlenko Source

Is it possible to get a range that is calculated from a formula? For example...

=MATCH("TEST",INDIRECT("C8"),0)

where C8 = A43:A

C8 uses the following formula, ="A"&C6&":A"

A43 is being calculated using a Match function which resides in cell C6

google-spreadsheetspreadsheet

Answers

answered 1 month ago pnuts #1

Maybe:

=MATCH("TEST",INDIRECT("A"&C6&":A"),0)  

with C6 merely containing a formula that returns, for example, 43.

comments powered by Disqus