LOOKUP Function

[Loadmaster]

D1:AJ1 have the years 2006:2038. C2:C13 have the months JANEC. D14:AJ14
total the columns D213, E2:E13 etc.... The total in AH14 which is 0.0 for
the year 2010 is 0.0 as we have not entered into that year as of yet. The
same for the rest of the row up to AJ14. I am looking for a formula that will
enter in cell B35 the total accumulated hours of just the current year from
D14:AJ14. I tried =LOOKUP(99^99,D14:AJ14) but naturally it is going to enter
0.0 from cell AJ14. How can I get it to read the current yearly hours from
Dec 2009 in cell G14?

 

[Mike H]

Hi,

Possibly this

=LOOKUP(2,1/(D14:AJ14>0),D14:AJ14)

Mike

 

[Shane Devenshire]

Hi,

It looks to me like you should use

=INDEX(D14:AJ14,,MATCH(YEAR(NOW()),D1:AJ1,))

 

[Loadmaster]

Thank-you it does work.

Hi,

Possibly this

=LOOKUP(2,1/(D14:AJ14>0),D14:AJ14)

Mike

 

[Shane Devenshire]

Hi,

The LOOKUP version would be

=LOOKUP(YEAR(NOW()),D1:AJ1,D14:AJ14)