| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Help with a function
If column A="TMT" then I want it to go to column h and pick up the value.
How do I set this up? |
|
#2
|
|||
|
|||
|
=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? |
|
#3
|
|||
|
|||
|
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? |
|
#4
|
|||
|
|||
|
Use the Fill function by selecting the cell in which the =IF(A2="tmt",H2,"")
code is placed. Lets say B2, then put your cursor over the bottom righthand corner of the cell, your cursor should change to a + symbol. Hold down your Left moouse button and drag down. This will change the code in the following way. A B C D E F G H 2 =IF(A2="tmt",H2,"") 3 =IF(A3="tmt",H3,"") 4 =IF(A4="tmt",H4,"") If you wish to keep any of the code the same like the referance to A2 then put a $ in front of the referance you wish to keep. A2 woudl become $A$2 When you do the fill option your code will look like this. A B C D E F G H 2 =IF($A$2="tmt",H2,"") 3 =IF($A$2="tmt",H3,"") 4 =IF($A$2="tmt",H4,"") Hope this helps. "Lisa" wrote: 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? |
|
#5
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date & Time | New Users to Excel | |||
| Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
| Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
Hybrid Mode
