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