Creating dynamic array from drop down box

[mojo476]

Hi all,
I've been trying to build a dynamic array that can be changed by using 2 combo boxes. I have managed to populate an array of "pizza places" that can carry the same peer group. So that one dropdown box selects a pizza place the other selects a peer group. Currently, if I select "Pizza Hut" with peer group 1 hard coded. My array will return dominoes and pizza hut.

The data looks like

pizza places	peer group 1	peer group 2	peer group 3
dominoes	1-4	5-8	5-8
pizza hut	1-4	1-4	1-4
little caesars	5-8	9-12	9-12
donatos	5-8	5-8	13-17
portefinos	9-12	1-4	5-8
papa johns	13-17	13-17	1-4

<tbody>
</tbody>

But if I want to dynamically adjust the peer groups it is returning a #value error. I am currently using Excel 2007 on a Windows XP machine.

Currently my formula is

=IF(ROWS(A7:A$7)<=$B$5,INDEX(pizzaname,SMALL(IF(peer1=$E$5,ROW(peer1)-ROW(Data!$AM$2)+1),ROWS(A7:A$7)),MATCH($A$5,Data!$1:$1,0),""))

I need to find a way to dynamically change "peer 1" named range to peer 2 and 3 dynamically using a combo box.

Thanks for any help!