Extracting numbers from a comma separated list for use in a lookup- formula solution

In MS Excel, a List of commas separated numbers
In a column, I have a text string number list ( up to four numbers) that represent row numbers in a table ( 'MyTable' in another worksheet). These numbers are entered by a user, that looks like the example list below:

23,234,2,16

The Goal using MS Excel
My goal, in the next column, is to perform and concatenate a lookup of each row number in the above list from a table.
E.g. Vlookup(23,MyTable,2,)&Vlookup(234,MyTable,7,) etc.

My question: The Challenge :-)
In excel, I need a formula to extract from the comma separated list above, each number in turn and use it as the lookup value in a series of concatenated VLOOKUP formulas as shown above. The list can contain between one and four numbers.

Any help will be much appreciated :-)

You can obtain the individual numbers in separate columns by using "Data" ==>"Text to Columns" with comma as delimiter.

You are clearly an Excel Goddess, thank you

Now, the only slight issue I have is, if a user enters a comma separated list like:

1,234,456,789

Excel rather unhelpfully (but with no doubt good intentions), makes the entry an integer which your amazing solution above can't handle. Is there a way to force Excel to not treat the list as a number?

I think I just sorted it- I used TEXT(A1,"#,#") function in place of just A1. It now all works.