View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sharmashanu sharmashanu is offline
external usenet poster
 
Posts: 28
Default vlook up formula help

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