View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
dan dan is offline
external usenet poster
 
Posts: 866
Default If empty, then display message


Can you provide a bit more info. Exactly what data is in the ranges A1:L1 &
A2:L2?

"puiuluipui" wrote:

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!