Saturday, April 14, 2018

yogi_Create A Template For Reporting Data By Specified Month Beginning With Monday In Which First Of The Month Falls

Google Spreadsheet   Post  #2424

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Apr-14-2018
How do you write a function as a range?
In Google Sheets, how do you create a variable range function?

I want to display a data set located somewhere else. So thought to use the INDEX function.
The problem is that I'm creating a template and thus the data set isn't always in the same place. So I thought to write the range for INDEX as an ADDRESS function and a MATCH function. However, no matter what I try I can't make it work.

An example [=index(address(match(J26,B:B),2,4):address(match(J26,B:B)+6,6,4))]

The problem seems to be that a function cannot serve as a variable. The INDEX function returns an error stating that the argument must be a range.

Is there a way to make this work or maybe a better way to get the same result?