Okay so heres what my workbook does thus far. I set the value in e3 by
looking up the text in b3 in a table array on the second sheet. I
would like to put this value in d3 if it is not zero. If it is zero I
want the user to be able to enter something into cell d3. But I don't
want the user to delete the formula in d3 so I would like to put it in
f3. Is this possible, or is there an easier way? Am I just over
thinking?