Hello all,

Without displaying the file since I'd have to really scrub - I use an array to look up names. Basically here is the array:

=INDEX('Monthly Exception Data'!$C$9:$C$33,SMALL(IF('Monthly Exception Data'!$D$9:$D$33=$D9,ROW('Monthly Exception Data'!$D$9:$D$33)-8,""),$B9),1)

In short:
There is a table with 25 names, all sorts of functions (HR, Marketing etc.) Can be any mix of any number of functions.
-I created a second table. This one uses function as the anchor to lookup. Everytime it finds the function, it returns that name to the top of the list
-When I drag the array down, it continues to list the names until there are no more in that function.
-I expected the blanks in my if formula to return blanks but instead i am getting a #num error

Any ideas from a high level? I can post a version of the file but maybe something I can get easily here.

Thx