Thread: If empty, then display message
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
puiuluipui puiuluipui is offline
external usenet poster
  
Posts: 468
Default If empty, then display message
Hi, i need this code to display a message if next or last (when it finds
first empty cell) cell in A1:L1 is empty.

=INDEX(A1:L1,MATCH(MONTH(TODAY()),MONTH(A2:L2)-1))
Can this be done?
Thanks!
Reply With QuoteReply With Quote