View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Max
 
Posts: n/a
Default dynamic formula needed

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
---