Lookup value above cells with non-zero value

  • Thread starter Thread starter hdf
  • Start date Start date
H

hdf

I have a table with two rows, 33 columns long. Top row has Years (200
to 2036) in it and the row below is intended for the inputing of value
in percentage form. Some of the cells in bottom row may be left blan
or with 0 value.

Elsewhere on my spreadsheet I want to create formulas that will retur
the top row value (year) for each year where the value in bottom row i
greater than 0.

For example, if

A1 = 2004 A2 = 2005 A3 = 2006 A4 = 2007
B1 = 0 % B2 = 5 % B3 = blank B4 = 20%

What formula in cell C1 will return value "2005" and in cell C2 th
next year value for which the cell in row B is not blank or 0, hence i
this case "2007".

Thank you,

Hecto
 
I have a table with two rows, 33 columns long. Top row has Years (2004
to 2036) in it and the row below is intended for the inputing of
values in percentage form. Some of the cells in bottom row may be
left blank or with 0 value.

Elsewhere on my spreadsheet I want to create formulas that will return
the top row value (year) for each year where the value in bottom row
is greater than 0.

For example, if

A1 = 2004 A2 = 2005 A3 = 2006 A4 = 2007
B1 = 0 % B2 = 5 % B3 = blank B4 = 20%

What formula in cell C1 will return value "2005" and in cell C2 the
next year value for which the cell in row B is not blank or 0, hence
in this case "2007".

Thank you,

Hector
Click to expand...

How about ...

=IF(ISBLANK(B1),"",IF(B1>0,A1,""))

Hope this helps.

Best,
Bill
 
Back
Top