# Need help with a formula

#### dizhopman

##### New Member
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!!

### Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
Try...

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

Hope this helps!

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

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

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

Replies
1
Views
314
Replies
8
Views
367
Replies
5
Views
490
Replies
3
Views
263
Replies
7
Views
452

1,203,082
Messages
6,053,419
Members
444,662
Latest member
AaronPMH

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back