| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to look up a value in list & return multiple answers
I have review a proceedure written by Ashish Mathur but I can not get it to
work. It continues to return a blank cell. Even when I copy the exact information the the example he gives. I have written the equation but I am having difficulty in determining where to mark the arrays The equation looks like this =IF(ISERROR(INDEX(N8:O411,SMALL(IF(N8:N411=N415,RO W(N8:N411)),ROW(1:1)),2)),"",INDEX(N8:O411,SMALL(I F(N8:N411=N415,ROW(N8:N411)),ROW(1:1)),2)) -- JW |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to look up a value in a list and return multiple corresponding | Excel Discussion (Misc queries) | |||
| return a list | Excel Worksheet Functions | |||
| Help with a lookup function that will give me multiple answers | Excel Discussion (Misc queries) | |||
| how to lookup a value and return multiple corresponding values | Excel Worksheet Functions | |||
| Single list from multiple sheets | Excel Worksheet Functions | |||
Linear Mode
