| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Array formulas/selecting data
Hi, I would like to use an array formula to retrive an array of data from a
column given a certain condition, for sake of example let the columns look like this A B 1 1 2 2 1 3 4 4 5 5 Selecting 2 cells and using the array formula (ctrl+shift+enter) If("A1:A5"=1;"B1:B5";"") yields the value 1 in both cells. What do I do to get the full array, in this case 1,3 in the cells respectively? I want to use this as a VLOOKUP function where the lookup range doesnt have unique elements so any other suggestions on this matter are highly appriciated as well. Brgds/ Kalle |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting 3 buttons out of a 3 x 3 array of options. | Excel Discussion (Misc queries) | |||
| Problems when sorting data containing array formulas | Excel Worksheet Functions | |||
| Vlookup - Array not selecting in other workbook | Excel Discussion (Misc queries) | |||
| Array formulas won't recognize external data from Microsoft Query | Excel Discussion (Misc queries) | |||
| selecting cells which contain formulas but return blanks | Excel Discussion (Misc queries) | |||
Threaded Mode
