Thread: Blank Cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
quattda quattda is offline
external usenet poster
 
Posts: 15
Default Blank Cell

I am using VLOOKUP to find and enter an associated time value in a cell (D2)
that is referencing another cell (D1). D1 generally blank until a text choice
is made using a drop-down list. I would like to not have the #N/A message in
D2 when D1 is blank. I could put in a generic character (such as ?) and use
the IF function. However, I was wondering if there is a way determine a blank
cell directly using the IF function?