Search Text String separated by Commas and do a Vlookup based on results

[Rschwar23]

Hi All,
Thank you in advance for your help.
I have a string of invoice numbers, separated by commas. I am trying to figure out how to have a macro look in the string on column G, do a vlookup for each invoice # (separated by a comma), and then put the total in column H.

I have attached an example spreadsheet. Column G:H are what I need to look for and paste results. Columns A:B are what the vlookup references.

Thanks!

[ragulduy]

Please Login or Register  to view this content.

?

[MickG]

Try this:-

Please Login or Register  to view this content.

Regards Mick

[patel45]

Please Login or Register  to view this content.

[Rschwar23]

Thank you all for your help! These worked perfectly. Have a great day.

[patel45]

Please Login or Register  to view this content.

?

very good solution, but there are numbers in column A then

Please Login or Register  to view this content.