Using Index function to pluck cells?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Don Wiss - 21 Mar 2006 01:52 GMT

Z6 is our index number. It can be either 1, 2, or 3. Putting numbers in an
array like this works:

=INDEX({1;1;0},Z6)

But I want it to pluck values from cells. So I tried this, which doesn't
work:

=INDEX({F6;K6;0},Z6)

I really don't want to move the values to adjacent cells to make a range.
Suggestions?

Don <www.donwiss.com> (e-mail link at home page bottom).

Reply to this Message

Tom Ogilvy - 21 Mar 2006 03:51 GMT

=choose(Z6,F6,K6,0)

Signature

Regards,
Tom Ogilvy

> Z6 is our index number. It can be either 1, 2, or 3. Putting numbers in an
> array like this works:
[quoted text clipped - 10 lines]
>
> Don <www.donwiss.com> (e-mail link at home page bottom).

Reply to this Message

Don Wiss - 21 Mar 2006 04:24 GMT

>> But I want it to pluck values from cells. So I tried this, which doesn't
>> work:
>>
>> =INDEX({F6;K6;0},Z6)

>=choose(Z6,F6,K6,0)

Thank you. I was not aware of the Choose function.

Don <www.donwiss.com> (e-mail link at home page bottom).

Reply to this Message

Tom Ogilvy - 21 Mar 2006 06:46 GMT

Within its limitations, it can be great. It is limited to 29 arguments.

Signature

Regards,
Tom Ogilvy

> >> But I want it to pluck values from cells. So I tried this, which doesn't
> >> work:
[quoted text clipped - 6 lines]
>
> Don <www.donwiss.com> (e-mail link at home page bottom).

Reply to this Message