Not what I want....

  • Thread starter Thread starter John21
  • Start date Start date
J

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
 
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
 
Back
Top