Return Most Recent (most left) Cell in a Range

[Tedmando]

I upload new data every week in a column. And I want a cell that retrieves the newest data I enter.

A1 | B1 C1 D1
4,000 | 2,300 3,000 4,000

I would A1 to return the newest cell. So next week I want A1 to retrieve the number that is in E1 when I enter something into E1.


Thanks! I've looked everywhere and everything else seems way more complicated than what I need.

 

[Jonmo1]

Welcome to the board...

I think you mean Furthest RIGHT...

Try

=LOOKUP(9.99999999999999E+307,B1:IV1)

Hope that helps.

 

[Tedmando]

Thank you for welcoming me and thank you for the quick reply!
Yes sorry I meant right. and thank you it worked! Appreciate the help

 

[Jonmo1]

You're welcome, glad to help.