View Single Post
  #1   Report Post  
DAVID
 
Posts: n/a
Default lookup nonzerovalues

I have two columns A and B. Column A contains ascending numbers from 1 to
100, column B contains arbitrary values (not in ascending order). What is the
function that looks for the first nonzero value in column B (going from the
frist to the last row) and returns the value of column A of the same row?