View Single Post
  #9   Report Post  
Harlan Grove
 
Posts: n/a
Default

Ragdyer wrote...
....
And since ISBLANK accepts total references,

=LOOKUP(2,1/(1-ISBLANK(1:1)),1:1)
should work OK, right?

....

Only because whole row references are no big deal - only 256 entries.
Whole column references still fubar.