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

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" wrote:

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

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?

"Duke Carey" wrote:

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" wrote:

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

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

"Desperate" wrote:

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?

"Duke Carey" wrote:

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" wrote:

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