Thread: Retrieving first non-blank cell during a V-LOOKUP
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Carim Carim is offline
external usenet poster
  
Posts: 510
Default Retrieving first non-blank cell during a V-LOOKUP
Ok then ...

Have a go with :

=INDEX(A1:A100,MATCH(TRUE,A1:A100<"",0))

Instead of Enter, use Shift Control Enter keys simultaneously to input
formula

HTH
Reply With QuoteReply With Quote