That's great, thanks. So you've used INDEX/MATCH rather than VLOOKUP. I wondered whether that was a better option.

I see that it looks up a range of cells rather than the table and when I added more products it automatically picked that up on the invoice which is exactly what I need.

Only question is that it tells me there is an error on the code and cost per unit cells. Any ideas what that would be or should I just ignore it?