Vlookup of two sheets

[Babalola]

[FONT=&quot]i have 2 sheets, in sheet 1 i have a site appering more than 1 time under site id colum with different enrty in collo response. i want the entry on a single coulmn for the unique entry in sheet 2
e.g
sheet 1 SHEET 2
COLUM A COULM B COULMN A COULMB
AB001 MANGO AB001
[/FONT]AB001 ORANGE AKW02
AB001 BANANA IM06
AKW02 APPLE
AKW02 PIG
IM06 RAT

I want all entry of ab001, akw02 and im06 on colum b in sheet one listed against the id on colum b in sheet2

e.g in shet2 AB001 MANGO,ORANGE,BANANA
AKW02 APPLE,PIG
IM06 RAT

 

[rlv01]

Re: Vlokkup of two shets

It is hard to make sense of your example, but the vlookup function should work for you. Here is a reference to the vlookup function that I like a lot. Perhaps it will help

https://support.office.com/en-us/ar...efresher-750fe2ed-a872-436f-92aa-36c17e53f2ee

 

[Babalola]

Re: Vlokkup of two shets

It is hard to make sense of your example, but the vlookup function should work for you. Here is a reference to the vlookup function that I like a lot. Perhaps it will help

https://support.office.com/en-us/ar...efresher-750fe2ed-a872-436f-92aa-36c17e53f2ee

OK
I have a sheet where a site say ab101 appears more than once on colum A and different collo responses. on column b . I want these different response to be on a single column b on against the site id on colum a sheet 2

 

[rlv01]

sheet 1 SHEET 2
COLUM A COULM B COULMN A COULMB
AB001 MANGO AB001
AB001 ORANGE AKW02
AB001 BANANA IM06
AKW02 APPLE
AKW02 PIG
IM06 RAT

You are posting data that is jumbled and hard to interpret. When I see that, I just get tired and start thinking about other things I need to do. Is there a reason you are not using the thread editor tools to insert your data as a table?

sheet2
[TABLE="class: grid, width: 200"]
<tbody>[TR]
[TD]COULMN A[/TD]
[TD]COULMB[/TD]
[/TR]
[TR]
[TD]AB001[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]AKW02[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]IM06[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Babalola]

sheet A
[TABLE="width: 500"]
<tbody>[TR]
[TD]colum a[/TD]
[TD]coulm b[/TD]
[/TR]
[TR]
[TD]ab101[/TD]
[TD]orange[/TD]
[/TR]
[TR]
[TD]ab101[/TD]
[TD]dog

[/TD]
[/TR]
[TR]
[TD]ab101[/TD]
[TD]apple[/TD]
[/TR]
[TR]
[TD]AB102[/TD]
[TD]CAR[/TD]
[/TR]
[TR]
[TD]ab102[/TD]
[TD]knife[/TD]
[/TR]
[TR]
[TD]ab103[/TD]
[TD]key[/TD]
[/TR]
[TR]
[TD]ab101[/TD]
[TD]book[/TD]
[/TR]
</tbody>[/TABLE]


sheet b

[TABLE="width: 500"]
<tbody>[TR]
[TD]colum a[/TD]
[TD]coulmn b[/TD]
[/TR]
[TR]
[TD]ab101[/TD]
[TD]ornage,dog,apple,book[/TD]
[/TR]
[TR]
[TD]ab102[/TD]
[TD]car, knife[/TD]
[/TR]
[TR]
[TD]ab103[/TD]
[TD]key[/TD]
[/TR]
</tbody>[/TABLE]


i want all entry against site ab101,ab102,ab103 in colum b of sheet a to be listed in colum b of sheet B as shown above