Vlookup and show value from adjacent cell.

[Pastilhas]

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

 

[Domenic]

Try...

C1, copied down:

=INDEX(Sheet1!$B$1:$B$4,MATCH(A1,Sheet1!$A$1:$A$4,0)+1)

Hope this helps!

 

[Pastilhas]

Thx for your help