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

COULMN A	COULMB
AB001
AKW02
IM06

<tbody>
</tbody>

 

[Babalola]

sheet A

colum a	coulm b
ab101	orange
ab101	dog
ab101	apple
AB102	CAR
ab102	knife
ab103	key
ab101	book

<tbody>
</tbody>

sheet b

colum a	coulmn b
ab101	ornage,dog,apple,book
ab102	car, knife
ab103	key

<tbody>
</tbody>

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