Hi,
I’m looking for a way to search a product name and then return a
sertain value from another column, example:

________ Column 1 ___ ____
Column 16
John ___ 45R,Lo59,Un58 ____
Res,49,ew
John ___ Op,PO,re,tu78 _____
Tuy,Ew,as
Angel ___ 48,ur,79,YU _____
ui48,8964P
John ___ Utr,lom,489 _____
oi8,loum
Angel ___ 78,Ld,Gu _____
Rul,MnO,789Y

For example lets say that the information is suppose to be in column
“A589”, so in this cell if I want the information about John of column
16, cell “A589” is going to contain
Res,49,ew, Tuy, Ew, as, oi8,loum. I have a code that is working to do
this but is working only for one name and I want all the names.
Example:
“A589” - Res,49,ew, Tuy, Ew, as, oi8,loum
“A590”- ui48,8964P, Rul,MnO,789Y


--
John21
------------------------------------------------------------------------
John21's Profile: http://www.excelforum.com/member.php...o&userid=36983
View this thread: http://www.excelforum.com/showthread...hreadid=571338