The "Fill Handle". See:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"Lisa" wrote in message
...
that works but how do we set it for the entire column?

"Anne Troy" wrote:

=if(a2="tmt",h2,"")
Hi, Lisa. What did you want if it doesn't = TMT? I made it so the cell
remains blank.
************
Anne Troy
www.OfficeArticles.com

"Lisa" wrote in message
...
If column A="TMT" then I want it to go to column h and pick up the
value.
How do I set this up?