Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hlookup problem
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
hlookup problem
I guess I am just trying to look up the last value in the row
"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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
hlookup problem
True should work but you say you have some dates in the data you do not want
to pull the content. Can you copy this over and eliminate the items you do not want? "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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
hlookup problem
Can't do that because there is other information in the array that is
important. Copying it over would be a solution in the short term (days), but this is for an ongoing inventory that is constantly turning over. So I really need it to lookup the last value using the entire array. "Don" wrote: True should work but you say you have some dates in the data you do not want to pull the content. Can you copy this over and eliminate the items you do not want? "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hlookup problem | Excel Discussion (Misc queries) | |||
HLookup problem with dates | Excel Discussion (Misc queries) | |||
Problem with HLookup - Sometimes works, sometimes blank. | Excel Discussion (Misc queries) | |||
Hlookup or Vlookup problem? or wich other solution? Complex Proble | Excel Discussion (Misc queries) | |||
Problem with application.Hlookup | Excel Discussion (Misc queries) |