# formula needed

#### mikenorris

##### Board Regular
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

### Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
Try

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

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

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)

Replies
0
Views
205
Replies
2
Views
190
Replies
5
Views
165
Replies
0
Views
148
Replies
0
Views
220

1,196,154
Messages
6,013,756
Members
441,781
Latest member
Gian Carlos

### 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