Hi Mazzaropi

The formula works perfectly, thank you! If you give me no more advice then I would still be very pleased. However, there are one or two aspects that you may be able to still give further advice for a perfect solution! - if you can spare the time?

• I would like to future-proof the spreadsheet, so that it works in several scenarios. For this to happen, I need to be able to edit the quantity and volume in the table. It would appear I can change the price but not the quantity? Is this doable?
• Is it possible to remove the formatting? I wish to cut and paste into a spreadsheet with its own format, but at present, I am finding it impossible to remove the colourful format that you have used. Very nice indeed! :-) Simply wrong for the spreadsheet I need to use the 
NB. I attempted to alleviate the problem by recreating the table and formula, but the formula using functions was difficult with my experience, so intend to find some tutorials to properly understand the IF, VLOOKUP and MATCH for future use.
• Can you tell me what 'Aux’ stands for?

Aprecio muito a vossa ajuda será este. Seu Inglês é muito melhor que o meu Português, mas o Google Translate função veio em meu socorro! Estou ansioso por ouvir de você novamente.

Muito melhores cumprimentos,
Colin