| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search and return
Hi, I’m looking for a way to search information in a column and then return the text found in another column that has related information. For example: Column1 Column2 John E,U4,L5 Angel HU,5,Lm Jenny Pedro 54,lkj,5UJ John return: E,U4,L5 Angel returns: HU,5,Lm Pedro return:54,lkj,5UJ So far i've using SUMPRODUCT with T. -- John21 ------------------------------------------------------------------------ John21's Profile: http://www.excelforum.com/member.php...o&userid=36983 View this thread: http://www.excelforum.com/showthread...hreadid=569067 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Search and return
John21 wrote: Hi, I'm looking for a way to search information in a column and then return the text found in another column that has related information. For example: Column1 Column2 John E,U4,L5 Angel HU,5,Lm Jenny Pedro 54,lkj,5UJ John return: E,U4,L5 Angel returns: HU,5,Lm Pedro return:54,lkj,5UJ So far i've using SUMPRODUCT with T. -- John21 Hi John21 If you enter the name to lookup in cell C1, try: =VLOOKUP(C1,A1:B4,2,FALSE) Regards Steve |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Search and return
Hi, I'm looking for a way to search information in a column and then return the text found in another column that has related information. For example: Column1 Column2 John E,U4,L5 Angel HU,5,Lm Jenny Pedro 54,lkj,5UJ John return: E,U4,L5 Angel returns: HU,5,Lm Pedro return:54,lkj,5UJ So far i've using SUMPRODUCT with T. -- John21 Hi John21 If you enter the name to lookup in cell C1, try: =VLOOKUP(C1,A1:B4,2,FALSE) Regards Steve John21 The problem is that the names in the column appear more than one time and the names appear randomly. Another exmaple: John lmj,45 Maria HI45,kil Jose John U15,U78 John M60,lem Angel lktr Jenny Angel nono,468 Maria John return: lmj,45,U15,U78,M60,lem Angel return: lktr,nono,468 -- John21 ------------------------------------------------------------------------ John21's Profile: http://www.excelforum.com/member.php...o&userid=36983 View this thread: http://www.excelforum.com/showthread...hreadid=569067 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search Multiple columns for criterion asterisk (*) and Return Numeric Label | Excel Worksheet Functions | |||
| Search column for value and return TRUE or FALSE | Excel Worksheet Functions | |||
| Search for first instance of text & return the value | Excel Worksheet Functions | |||
| Multiple search criteria to return one response | Excel Worksheet Functions | |||
| search multiple worksheets for an item and return the Wsheets name | Excel Worksheet Functions | |||
Hybrid Mode
