I have a query which I am unable to solve.
I have certain Codes in Sheet1 as below
A B C 1 CODES OUTPUT SUM 2 991121QR5, 991121XSX, 991234SSC, 991121SDF 2 991121QR5, 991121XSX, 991234SSC 2 991121QR5, 991121XSX, 991234SSC, 991121SDF
Table in Sheet 2 is as follows:-
A B 1 CODES VALUE 2 991121QR5 100100 3 991121XSX 888888 3 991234SSC 123456 4 991121SDF 121212
The Final Outcome in Sheet 1 should be as follows:-
A B C 1 CODES OUTPUT SUM 2 991121QR5, 991121XSX, 991234SSC, 991121SDF 100100, 888888, 123456, 121212 1233656 2 991121QR5, 991121XSX, 991234SSC 100100, 888888, 123456 1112444 2 991121QR5, 991121XSX, 991234SSC, 991121SDF 100100, 888888, 123456, 121212 1233656
How can I get the above OUTCOME 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. Also how to add up all the values of b2 in c2.
I have posted the same in other forums but have not received any solution as per requirement.
https://chandoo.org/forum/threads/vl...comma-s.36769/
https://www.mrexcel.com/forum/excel-...pace-cell.html
https://www.excelforum.com/excel-for...he-series.html
https://www.ozgrid.com/forum/forum/h...by-comma-space
Bookmarks