Help with a function

L

Lisa

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

Mike Punko

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.
 
Top