Not what I want....

[John21]

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

[Simon Lloyd]

Why dont you change whatever is the trigger to find the name to an Inputbox and get it to look for the inputbox value?

Regards,
Simon