| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for finding an element
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "bim-bom" wrote in message ... T. Valko pisze: One way... Array entered** : =INDEX(C1:C3,MATCH(1,IF(A1:A3=5,IF(B1:B3=6,1)),0)) ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER. Thank you very much - it works perfectly. Now I know how to know make things like that. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to use a single nonrepeating XML element in a cell formula | Excel Discussion (Misc queries) | |||
| look for missing element | Excel Worksheet Functions | |||
| nth element extract | Excel Worksheet Functions | |||
| How to define the 1st, 2nd and 3rd element | Excel Worksheet Functions | |||
| How do I prevent a formula element from incrementing when copying | Excel Worksheet Functions | |||
Threaded Mode
