Thread: Empty cell return a value from another cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
hilltop55 hilltop55 is offline
external usenet poster
  
Posts: 8
Default Empty cell return a value from another cell
Re-phrase quesiton.


I want to put a formula in a cell to look at a cell and if it is blank I
want to return the value from another cell if not blank return nothing.

Cell A1 is blank, I want to put a formula in cell c1 that will look in B1
and return to A1 the value of B1. Else do nothing.
--
Thanks for your help.
Reply With QuoteReply With Quote