How to look up a value in list & return multiple answers

J

Jerry

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 thi
=IF(ISERROR(INDEX(N8:O411,SMALL(IF(N8:N411=N415,ROW(N8:N411)),ROW(1:1)),2)),"",INDEX(N8:O411,SMALL(IF(N8:N411=N415,ROW(N8:N411)),ROW(1:1)),2))
 
Top