formula needed

[mikenorris]

Is there a way to have a formula look for the last number entered in a column and return that value?

Sheet Name: Totals
B13 - Formula to return last number entered in column B on Sheet name: Dallas - Should return the number 1234

Sheet Name: Dallas
Column B
111
222
333
444
1234

If I added 1299 to the list, B13 on the totals sheet would then return 1299 instead of 1234 like previously

 

[barry houdini]

Try

=LOOKUP(9.99999999999999E+307,Dallas!B:B)

 

[mikenorris]

Can you explain what all the 99999999E+307 means? The formula works, but I was just curious

 

[barry houdini]

9.99999999999999E+307 is the largest number you can enter in a cell (see Excel Help - Specifications and Limits). In this formula it needs to be a number that is greater than any number that might appear in your data, so if the largest number you use in column B is 9999 then it would be sufficient to use a number greater than that, perhaps just

=LOOKUP(10000,Dallas!B:B)