Hi all
Nedd some help.
I need a way to take data from one sheet to another one.
Exemple: Sheet 1
---------Col.A --- Col.B --- Col.C
Line 1 -- 10 ----- David --- AA <----- Part from first data
Line 2 ----------- Boy ------ BB <---- Part from first data
Line 3 -- 22 ----- Joana --- CC <-- Part from secound data
Line 4 ----------- Girl ------- AA <-- Part from secound data
I make this formula in sheet 2
=Vlookup(A1;'Sheet 1!$A$1:$C$4;2;FALSE)
Exemple: Sheet 2
---------Col.A --- Col.B --- Col.C
Line 1 -- 10 ---- David ---
Line 3 -- 22 ---- Joan -----
But i whent one formula capable of showing in Col.C data from secound line from first data, data from secound line from secound data ect ...
Exemple: Sheet 2
---------Col.A --- Col.B --- Col.C
Line 1 -- 10 ----- David --- Boy
Line 3 -- 22 ----- Joan ---- Girl
Sorry for my dam poor english. hope someone can help me.
thx
Nedd some help.
I need a way to take data from one sheet to another one.
Exemple: Sheet 1
---------Col.A --- Col.B --- Col.C
Line 1 -- 10 ----- David --- AA <----- Part from first data
Line 2 ----------- Boy ------ BB <---- Part from first data
Line 3 -- 22 ----- Joana --- CC <-- Part from secound data
Line 4 ----------- Girl ------- AA <-- Part from secound data
I make this formula in sheet 2
=Vlookup(A1;'Sheet 1!$A$1:$C$4;2;FALSE)
Exemple: Sheet 2
---------Col.A --- Col.B --- Col.C
Line 1 -- 10 ---- David ---
Line 3 -- 22 ---- Joan -----
But i whent one formula capable of showing in Col.C data from secound line from first data, data from secound line from secound data ect ...
Exemple: Sheet 2
---------Col.A --- Col.B --- Col.C
Line 1 -- 10 ----- David --- Boy
Line 3 -- 22 ----- Joan ---- Girl
Sorry for my dam poor english. hope someone can help me.
thx