| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
retrieving information
In one worksheet i have many columns with information which is names and skills of that name in a corresponding row, I want to search and view this information, im using a match zero formula however I can only get one answer when I would like all of them. How can I achieve this? hope someone can help -- hsb101 ------------------------------------------------------------------------ hsb101's Profile: http://www.excelforum.com/member.php...o&userid=37049 View this thread: http://www.excelforum.com/showthread...hreadid=567770 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
retrieving information
i switched to lookup formula but still getting one result (the final one) - but their is multiple answers in one column i am basically matching a text to a cell and need to retrieve information from a row that matches the cell -- hsb101 ------------------------------------------------------------------------ hsb101's Profile: http://www.excelforum.com/member.php...o&userid=37049 View this thread: http://www.excelforum.com/showthread...hreadid=567770 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing information from 2 workbooks into a 3rd one | Links and Linking in Excel | |||
| Importing information from 2 workbooks into a 3rd one | Excel Worksheet Functions | |||
| Importing information from 2 workbooks into a 3rd one | Excel Discussion (Misc queries) | |||
| Switching Information | Excel Discussion (Misc queries) | |||
| Retrieving information for a day of the week... | Excel Worksheet Functions | |||
Linear Mode
