vlook up formula help

  • Thread starter Thread starter sharmashanu
  • Start date Start date
S

sharmashanu

Hi All
Can anyone tell how can I correct this formula
=VLOOKUP(""<>0,A2:B33,2,TRUE)
All i am trying to do is- I have a column with zero's and i am trying
to find the first cell that has value not equal to zero. ( negative or
positive) . Please tell me if this way is wrong, then suggest me some
other.

Thanks
Shanu
 
One way with this ARRAY formula that must be entered using ctrl+shift+enter
where you find the first number >0 and look 2 columns to the right
=INDEX(J2:J22,MATCH(MIN(IF(H2:H22>0,H2:H22)),H2:H22))
 
You may have to use .000001
=INDEX(J2:J22,MATCH(MIN(IF(H2:H22>0.00001,H2:H22)),H2:H22))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Array VLOOKUP lookup_Value does not increment 3
select multiple cells 3
creating a value for a file name 1
Vlook-up in report with column Expansion 5
Delete Rows with Conditions 1
Excel Need Countifs Formula Help 0
Formula for getting the breakup of net amount 1
Combining Text based on Values 8

Back
Top