I have a data range (exported monthly via CSV) of sales & purchase invoices plus the account reference each of them have been raised against.
I then have a list of current month invoices (including both sales & purchase) for which I would like to return the account reference for each.
I can't do a straightforward VLOOKUP because some of the invoice numbers are grouped together in one cell, separated by commas.
Is this solution possible?
Example attached.
ANY help at all would be appreciated - I'm so stuck
Thank you,
Laura
Bookmarks