Thread: IF question complicated
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default IF question complicated
Hello,

Array-enter into C1:
=IF(ISBLANK(A1),"",INDEX(B2:B$65536,MATCH(FALSE,IS BLANK(B2:B$65536),
0)))

Regards,
Bernd
Reply With QuoteReply With Quote