1:N mappings
 

I want to establish multiple mappings between an item (represented by a
row in one worksheet) with values within an array on another worksheet
in a way that I can iterate through the arbitarily long list of values
(mappings). So, I'm thinking that I might enter a comma-separated list
of array values into a single cell on the item's row. Is there a
function that will provide access to the comma-separated values with
which I can then use the LOOKUP function to access the corresponding
value in the array? Or perhaps there a better solution?

TIA,
David