| 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). |
| 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 | |||
Threaded Mode
