It seems to me that I am getting strange output of an excel formula and for the life of me I can't figure out why. Could someone explain why I am getting these results?

The goal of this array formula is to list all the first names of the people with a certain eye color. In this example Blue

only one worksheet is being used for the use of this question:

A | B | C | |

4 | Color: | Blue | |

First Name | Last Name | ||

8 | |||

9 | |||

10 | |||

11 | #NUM! | #NUM! | |

12 | #NUM! | #NUM! | |

13 | #NUM! | #NUM! | |

31 | Color | First Name | Last Name |

32 | Blue | Ronald | Washington |

33 | Green | Mary | Ramirez |

34 | Blue | Pete | Rogers |

35 | Blue | Susie | McNickel |

<tbody>

</tbody>

The formula that I am using in A8 through A10 is as follows:

Code:

`{=INDEX($A$32:$C$106,SMALL(IF($A$32:$A$106=$B$4,ROW($A$32:$A$106)),ROW(A8:A8)),2)}`

For some reason as you can see above it has a blank cell for the values.

I did try one other formula that I found on the web:

Code:

`=INDEX($B$32:$B$106, SMALL(IF(ISNUMBER(SEARCH($B$4, $A$32:$A$106)), MATCH(ROW($A$32:$A$106), ROW($A$32:$A$106))), ROW(A8)))`

All help is appreciated as I have been struggling with this for the last week.

later

Ty