I intend to locate a cell that records the first value which is not zero (an
example is given below). The Index and Match functions don't seem to work.
Any solutions would be highly appreciated.

01/06/05 01/12/05 01/06/06 01/12/06 01/06/07
0% 0% 5% 40% 0%

I intend to capture the cell with date "01/06/06", which shows 5% - i.e. the
first cell from the second row which is not zero.