
New Member

July 1, 2019

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


New Member

July 1, 2019

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)
