Log In
Register
Home
New Member
July 1, 2019
Offline
I'm trying to do a pretty simple formula, to get the last non blank cell in a row. I've used this formula before, and it has been fine, but for some reason it's not working on this sheet. Any ideas as to why??
I'm using =LOOKUP(2,1/(I12:P12<>"") and getting a result of #N/A
I initially had a result vector in it of I12:P12 as well, but still getting the same result.
Here is a sample:
| Creation Date | Turn 1 | Turn 2 | Turn 3 | Turn 4 | Turn 5 | Turn 6 | Screen | |
| 5/06/2019 | ||||||||
| 5/06/2019 | ||||||||
| #N/A | 5/06/2019 | 27/06/2019 | ||||||
| 6/06/2019 |
VIP
Trusted Members
June 25, 2016
Offline
Hi Kim
Try this
=LOOKUP(2,1/(I12:P12<>""),I12:P12)
Sunny
New Member
July 1, 2019
Offline
Hi Sunny,
I had actually tried that first, but with the same result. However, I thought why not give it a go again, when I saw your answer, and for some reason it is now working. The only thing I can think is that I've been doing all sorts of other things on the spreadsheet today and whatever was stopping it from working initially has been resolved.
Cheers.
1 Guest(s)
