Return previous value formula

[gabster77]

Hi,

Ok, I've got part of this solved out, but now it's driving me nuts. I have multiples columns with different prices. I created myself a new column that needs to do this:

If column H1 already has a value then do nothing. Otherwise look a the previous cell in the adjacent column and return the latest value.

The catch here is some cells in the previous columns are empty and I need to have the latest value which is not 0. This is because the product is discontinued but I need to have the last price when it got discontinued in my new column.

This is what I have, my problem is B2:G2, it will return the value it encounters from B2 to G2. I need it to go the other way G2:B2, how the hell do I do this

=IF(ISBLANK(H1),CELL("content",B1:G1),CELL("content",H1))

Please tell me there is a solution without having to do a macro!
Thx
Regards

[NBVC]

=LOOKUP(9.999999e+307,B2:G2) will look up the last numeric entry in that range.

If you have 0's in there and not blanks...

then =LOOKUP(2,1/(B2:G2<>0),B2:G2)