Hello,
I am trying to lookup the first >0 value in a range (U17 to u 1500)
the lookup function I have been trying
=LOOKUP(2,1/(U17:U1500>0),H17:H1500) returns the last value in the range. I need the first value in the range instead. How can I do that?
basically if cell U20 has a value >0
and if cell U300 has also a value >0
with the above formula I get the result of H300.
I would need the value of H20 (being the first) as a result not the one of H300 which is further down in the column.
Thank you so much
Nino
Bookmarks