Forum Discussion
Text Extraction and Sum with Vlookup
Hello all, I have thought all day about this problem without any solution. I have a table with a many codes in single cell (see below). I need to extract ( comma as delimiter) each single cod...
SergeiBaklan Thanks you,
is there a possibility to do also the sum through Vlookup in a solo formula?
It all depends on which Excel version/platform do you use and how your data is structured. In any case it'll be few formulas - split codes, lookup values for codes and sum them. On Excel with dynamic arrays perhaps you may combine all together in one block.
- I have Office365.
