Hlookup error

[Desperate]

I am trying to use an hlookup using the date as the lookup-value. In the case
that it finds a zero for that entry, I would like it to lookup the previous
entries until it finds a value. I have tried using TRUE in the logical range
lookup, but since all dates appear it still returns a zero. I have also tried
using an IF stantement as follows: =IF(HLOOKUP(date,formula)=0,
HLOOKUP(date-1,formula), HLOOKUP(date, formula)) but this will only work for
the very next day and wont continuously loop for 2 or more. Can anyone help
me?
Note: In one case the cell value is actually 0 and in another case the cell
value is blank

 

[Duke Carey]

Is this different than your earlier problem? Have you tried to solve it by
using ALL dates? That road goes nowhere.

Take a look at my second response to your earlier question

 

[Desperate]

Yes, this is different than my last problem. I am trying your second solution
to the first problem and it is returning some oddball stuff right now. To be
honest, I don't get it. I can put the dates into either ascending or
descending, but I guess I want to use descending if I need to get a value
equal to or larger, right? Then what I want the sheet to return is the date,
so the index is in the same column, right?

 

[Desperate]

It works but isn't there a way to add the dates to the bottom of the list
rather than the top