Need help with a formula

[dizhopman]

I'm trying to get a formula to work here. I am adding data for each month like so...

Jan Feb March
20 23 19

Then I have a cell at the end, and I need this cell to return the latest month's input. So in Feb. the cell should say 23, in March it will say 19. How do I get excel to automate this for me?

Thanks!!

 

[Domenic]

Try...

=LOOKUP(9.99999999999999E+307,A2:L2)

Adjust the range accordingly.

Hope this helps!

 

[adam_neb]

Cool answer, but how in the heck does that work?

 

[cfree36]

=HLOOKUP((TEXT(TODAY(),"mmm")),D9:O10,2,0)

Assuming your months are JAN, FEB, etc...
and your data is in row 2

 

[Domenic]

Cool answer, but how in the heck does that work?

Have a look at Aladin's explanation in the following link...

http://www.mrexcel.com/board2/viewtopic.php?t=105725