| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Index function to pluck cells?
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). |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using Index function to pluck cells?
=choose(Z6,F6,K6,0)
-- Regards, Tom Ogilvy "Don Wiss" wrote in message ... 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). |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using Index function to pluck cells?
On Mon, 20 Mar 2006 21:51:14 -0500, Tom Ogilvy wrote:
Don Wiss wrote: 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). |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using Index function to pluck cells?
Within its limitations, it can be great. It is limited to 29 arguments.
-- Regards, Tom Ogilvy "Don Wiss" wrote in message ... On Mon, 20 Mar 2006 21:51:14 -0500, Tom Ogilvy wrote: Don Wiss wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using INDIRECT Function and INDEX Function | Excel Discussion (Misc queries) | |||
| Index function - problem copying to other cells | Excel Worksheet Functions | |||
| Index Function/Match Function | Excel Discussion (Misc queries) | |||
| How to pluck out initials of a 2 or 3 word name | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Linear Mode
