D
Don Wiss
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).
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).