Quote:

> I need to formula to get a value from an offset cell where the value of

> the cell is less than or equal to 0.

> for example

> A B C

> 1 100 12 july 16 july

> 2 50 13 july 16 july

> 3 20 14 july 16 july

> 4 10 15 july 16 july

> 5 0 16 july 16 july

> 6 -10 17 july

> 7 -20 18 july

> If the values in columns A or B change then the value of C also need to

> change.

> Thanks

> ian

Your question is not very clear to me but I guess you want to

calculate the values in column C. Well the following function does

that:

=IF(A1<0,"",INDEX($B$1:$B$7,MATCH(0,$A$1:$A$7,0)))

=IF(A2<0,"",INDEX($B$1:$B$7,MATCH(0,$A$1:$A$7,0)))

=IF(A...<0,"",INDEX($B$1:$B$7,MATCH(0,$A$1:$A$7,0)))

Pretty slow if you have a big sheet.

better is in cell D1:

=INDEX($B$1:$B$7,MATCH(0,$A$1:$A$7,0))

and then:

=IF(A1<0,"",$d$1)

etc...

Regards,

Paul