Trying to concatenate an array name

[Bstranger]

I am using a drop down combo box. The user selects an item from the combo box to which I concatenate the word Prices which in turn becomes an array name. If I explicitly name the array (_6600_Prices) my pricing array returns pricing as expected. Here is example of code that works.

=INDEX(_6600_Prices,MATCH(I2,Tables!N4:N7,1),MATCH(H2,Tables!O3:X3,1)).

If I try to concatenate the array name as follows I get a #value ! Error. B2 has a value of _6600_

=INDEX(B2&"Prices",MATCH(I2,Tables!N4:N7,1),MATCH(H2,Tables!O3:X3,1))

I am a newbe to this forum, thanks in advance for any help

 

[shg]

=INDEX(INDIRECT(B2 & "Prices"), ...

 

[Bstranger]

Thank you so much, works great. I can't tell you how long I struggled with this