A cell can only house either a formula or a value at any one time. You'd
need a sub to achieve this. There are responders versed in vba who could
help you (I'm not one of them). Suggest that you put in your new query as a
new posting.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Astroboy" wrote in message
...
Hi Max,

One More question: :)

In Cell 16:

If input is A then ABC will show on same Cell (Cell 16)
If input is D then DEF will show on same cell (Cell 16)
If input is N then N will show on same cell (Cell 16)
And "blank" if the input in Cell 16 is other than
what I described above.

Any Idea?

And again Thank you!!!!!