Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Not what I want....
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Not what I want....
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 -- Simon Lloyd ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708 View this thread: http://www.excelforum.com/showthread...hreadid=571338 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|