| 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 |
| 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 | |||
Threaded Mode
