View Single Post
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default

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