[SOLVED] Vlookup value after comma+space and return each value separated by comma+space

[sandeepsandeep]

I have a query which I am unable to solve.

I have certain Codes in Sheet1.

How can I get the OUTCOME as attached using one single formula to vlookup each value from cell A2 after comma+space from sheet1 with the table in sheet2 and place the output in same format as in cell a2 of sheet 1 in cell b2 of sheet 1. This should repeat till the last comm+space is there in the series. Also how to add up all the values of b2 in c2.

 

[bosco_yip]

Cross posted :

https://www.mrexcel.com/forum/excel-questions/1036203-vlookup-value-after-comma-space-return-each-value-seperated-comma-space-till-last-comma-space-cell.html

Regards
Bosco

 

[sandeepsandeep]

Cross posted :

https://www.mrexcel.com/forum/excel-questions/1036203-vlookup-value-after-comma-space-return-each-value-seperated-comma-space-till-last-comma-space-cell.html

Regards
Bosco

That post does not give the required result.

 

[bosco_yip]

That post does not give the required result.

Hi,

The forum rules allow cross-posting as long as you provide a link to the other website.

This is to consider people in here can know what are the answers posted by the other website.

Regards
Bosco

 

[sandeepsandeep]

Hi,

The forum rules allow cross-posting as long as you provide a link to the other website.

This is to consider people in here can know what are the answers posted by the other website.

Regards
Bosco

https://chandoo.org/forum/threads/v...d-by-comma-space-till-the-last-comma-s.36769/

https://www.mrexcel.com/forum/excel...d-comma-space-till-last-comma-space-cell.html

https://www.excelforum.com/excel-fo...lues-till-last-comma-space-in-the-series.html

 

[sandeepsandeep]

Query Solved. Thread closed

https://www.excelforum.com/excel-fo...es-till-last-comma-space-in-the-series-3.html