Re: using a set of values

[Jody Goldberg <jgoldberg home com>]

On Sat, Jan 27, 2001 at 01:33:34PM +0100, anders alm wrote:
> but i have a little (prolly trivial) problem i'd really apreciate if i could
> solve... let's say i wanna try out some different sets of values, like on
> a1-a25 i have one set, and on b1-b25 i have another etc.. how can i make it so
> i only need to change one value (somewhere) to get access to each set? 
>
> to simplify my problem i'd like to do something like this: 
> define SET = 'b' 
> to get access to the first row in that set i'd use something like =${SET}$1
> etc... 

The simplest case would be
    =if(set='a',a1:a25,b1:b25)

a more complex solution would be (convert set to an integer)
    =offset(a1:a25,0,set,25,1)