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
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