can you not use a combo box that used the range?

result of pick is stored in C7 (the index# of the pick)
C8 = the text result of C7: INDEX(A3:A323,C7)