Vlookup and show value from adjacent cell.

Pastilhas

New Member
Joined
Oct 18, 2006
Messages
2
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
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Domenic

MrExcel MVP
Joined
Mar 10, 2004
Messages
19,309
Try...

C1, copied down:

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

Hope this helps!
 

Watch MrExcel Video

Forum statistics

Threads
1,109,518
Messages
5,529,314
Members
409,863
Latest member
stacy09
Top