- 0

## 3 answers to this question

## Recommended Posts

## Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

The time has come! The new website is up and running https://www.excelwtf.com/learn/ Check it out if you want to learn VBA or brush up on your Excel skills with some more advanced Excel tutorials!

News Ticker

- Welcome to the Community
- Use the forum to troubleshoot your Excel & VBA Problems
- We will be launching a new website soon! www.ExcelWTF.com/Learn ! Join us to learn VBA from the ground up!

- 0

You can post now and register later. If you have an account, sign in now to post with your account.

Hi Caleeco

Looks like you've been having it pretty easy with me not pestering you with my problems.

However, I have a new problem. Still on the same spreadsheet as previous, but a little enhancement has stopped working.

I've been using =LOOKUP(2,1/(1-ISBLANK(S:S)),S:S) to find the last value in a column that consists of blanks and manually entered numbers. It worked fine until I decided to use a formula to automatically enter new values in the column instead of me entering them manually. There are now about a hundred blank cells in the lower section of the column, each with an underlying formula. Now my =LOOKUP cell is blank; presumably it's showing the value of the last formula in the column - a blank.

How do I resolve this? I searched the 'net and tried an assortment of similar formulae, but nothing worked. Now I need proper help.

As always, I'm open to using a formula or VBA, whichever is the more efficient.

Many thanks.

## Share this post

## Link to post

## Share on other sites