| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiple results from search / how to?
Hi,
Illustrative example of my problem: I have a list of numbers and letters. How can I lookup the value " 1 " and return the multiple results of z, a, g ? I want to type only one formula in one cell, although I don't mind the result being spread out over multiple cells. Thanks for your thoughts on this. 1 z 2 b 1 a 3 e 4 f 1 g |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiple results from search / how to? | Excel Discussion (Misc queries) | |||
| Resizing search results window | New Users to Excel | |||
| How can I view multiple search results? | Excel Discussion (Misc queries) | |||
| How do I search excel spreadsheets using multiple search criteria. | Excel Worksheet Functions | |||
| Print the results of a search | Excel Discussion (Misc queries) | |||
![ORLANDO V[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
