View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DebbieV DebbieV is offline
external usenet poster
 
Posts: 20
Default Return value in non-blank cell

Hi

I have dates in some cells and remainder blank in column A if I want
to return the value located in A3 in F3 how do only return a value if
it is a non-blank?

(I have done this before but memory is 'blank'!)

thanks
Debbie