Cuscino
03-27-2018, 10:47 AM
Hi Everyone, VBA noob here (and new to this forum)
I m looking for a particular VBA vlookup that seeks multiple values in one cell separated by a comma (name of the product eg. FHGH, RDSD, etc), in another file.
In this last one, we have: in the first column the values to find in each single row, but they´re incorporated in a full sentence (eg. FHGH Product 12 6volt)
I would like the formula to return to me the sum of the values that are in the second column (where there are the prices of each product)
I hope you could help me https://www.mrexcel.com/forum/images/smilies/icon_wink.gif
Thanks
I m looking for a particular VBA vlookup that seeks multiple values in one cell separated by a comma (name of the product eg. FHGH, RDSD, etc), in another file.
In this last one, we have: in the first column the values to find in each single row, but they´re incorporated in a full sentence (eg. FHGH Product 12 6volt)
I would like the formula to return to me the sum of the values that are in the second column (where there are the prices of each product)
I hope you could help me https://www.mrexcel.com/forum/images/smilies/icon_wink.gif
Thanks