Help needed with #REF! error (arrays)

Hi,
Need fresh eyes on this one.
For the life of me I cannot work out why I receive a #REF error with this array.
It's producing the right number of results for the arguments, but is displaying REF which does not make sense to me because values exist in the referenced cells.

using this formula:

IF(ROW()-94>COUNTIF($J$88:$J$91,$H$94),"",INDEX(H$87:H$91,SMALL(IF($J$88:$J$91=$H$94,ROW($J$88:$J$91),""),ROW()-94)))

Spreadsheet attached.
Thanks in advance.
Cam

Your IF function within the SMALL function returns a value between 88 and 91 whereas INDEX with a four cell range needs to be fed a number between 1 and 4, hence the #REF! error.

....so you need to change ROW($J$88:$J$91) to ROW($J$88:$J$91)-ROW($J$88)+1. You can also make a few small changes to make the formula more robust. I'd use this in H95 copied down

=IF(ROWS(H$95:H95)>COUNTIF($J$88:$J$91,$H$94),"",INDEX(H$88:H$91,SMALL(IF($J$88:$J$91=$H$94, ROW($J$88:$J$91)-ROW($J$88)+1,""),ROWS(H$95:H95))))

confirmed with CTRL+SHIFT+ENTER

awesome. thanks for making it more robust too - was having an issue with its 'delicacy'

cheers!