| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to look up a value in a list and return multiple corresponding
I can make the formula look up anumber but i need it to look for a specific
word. What can i replace "SMALL" with to have the formula bring all intances of the word "Active" =SMALL(IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)),ROW(1:1) ) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return multiple values in a list? | Excel Worksheet Functions | |||
| How to look up a value in a list and return multiple corresponding | Excel Discussion (Misc queries) | |||
| How to look up a value in list & return multiple answers | Excel Discussion (Misc queries) | |||
| How to look up a value in a list and return multiple corresponding | Excel Discussion (Misc queries) | |||
| How to look up a value in list & return multiple corresponding val | Excel Discussion (Misc queries) | |||
Threaded Mode
