Vlookup with multiple values in one cell.

[jamesjhhill]

Hi Guys, I hope you can help.

I would like to enter a list of invoice numbers into one cell and have a formula which identifies these and provides a total.

So for example, if I enter invoice numbers 234,251 it would lookup those two invoices from a list and provide a total. I've put together a quick example which is attached!

Really appreciate your help!

Thanks, James

[XLent]

One possible option:

Please Login or Register  to view this content.

[jamesjhhill]

This is perfect! Thanks so much. James