=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?