Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
One way ..
Try something along these lines In 1.1, Placed in C6, array-entered with CSE*: =INDEX(Main!$F$6:$F$15,MATCH(1,(Main!$B$6:$B$15=D6 )*(Main!$E$6:$E$15=$E$3),0)) C6 is then copied down *press CTRL+SHIFT+ENTER to confirm the formula (instead of just pressing ENTER) Similarly, in 1.2, Placed in C6, array-entered wih CSE: =INDEX(Main!$H$6:$H$15,MATCH(1,(Main!$B$6:$B$15=D6 )*(Main!$G$6:$G$15=$E$3),0)) C6 then copied down -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"Unable to set the Formula property of the Series class" with a tw | Charts and Charting in Excel | |||
continuous sum formula needed | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) |