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!
Bookmarks