Using the same principle this is three characters fewer:

=INDEX(B$2:B$6,ROW()-1+(B10)*(B20))*((F2<=0)*(G2<7))

There is no *false* argument in either of the formulas so they both return
FALSE. This one returns 0, which may not suit the OP's requirements.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Perhaps =IF(AND(F2<=0,G2<7),INDEX(B$2:B$6,ROW()-1+(B10)*(B20))) ?
--
David Biddulph

"cprao" wrote in message
...
I have found the following formula. Can anybody give shorter than this. It
would be helpful.

=IF(AND(F2<=0,G2<7),INDEX(B$2:B$6,IF(COUNTIF(B1:B2 ,"0")1,ROW(),ROW()-1))
--
cprao