If sheet 1 column 4 says hol then it fills in columns A1,B1 and

Closed
scarey3 Posts 4 Registration date Tuesday October 15, 2013 Status Member Last seen February 12, 2014 - Jan 31, 2014 at 02:38 PM
 Blocked Profile - Jan 31, 2014 at 05:12 PM
Hello,
I have 2 sheets in excel 1st sheet has:
1st column has employee Team A1
2nd column has employee number B1
3rd Column has Employee name C1
4th column has HOL or shift pattern D1

The second sheet has 3 columns
A1 = employee team
b1 = employee number
c1 = employee name

What I want to do is if sheet 1 column 4 says hol then it fills in columns A1,B1 and C1 on sheet 2 with the info from sheet 1

Regards

scarey

Related:

1 response

Blocked Profile
Jan 31, 2014 at 05:12 PM
Scarey,

I hope I am not doing homework!

ok, hang tight!
if function: =if(logic_test,true, false)

So, let us look at the first thing:address.




So then, take that function, click on the cell, and drag it down [notice the address locations changes are relative to the cell that is calling it]. The function always needs to see if qualitying cell has HOL.

It will transfer the blank lines, so if line 12 has HOL, then line 12 on second sheet is filled, it DOES NOT LOOK FOR NEXT ROW on second sheet! What do you want for free? :)

Let us know if this helps.

Have Fun!
//ark
-Moderator/Contributor
0