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 |
Hi Kim
Try this
=LOOKUP(2,1/(I12:P12<>""),I12:P12)
Sunny
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.
Hi Kim
Glad to know you got it sorted out.
Sometimes Excel can behave in an unexpected way.
Cheers
