Hi Excel Guru's. Hope you are all well?!

The help I received on here last week was amazing so here i am back for some more...

I have created a new invoice sheet : looking to complete it with auto VAT calc.

Table is headed as:
Description | Staff | Rate | Hours | VAT Rate

Firstly I have dropdown lists for different staff rates - using VLOOKUP this works perfect!

VAT Column: is a dropdown list using validation

F14 - 18 = lists contain 20% / 5% / 0% VAT

So dependent on the charge you pick. It’s here that I am trying to get the subtotal, VAT and Total Cost to work in order of the VAT .
The invoice could contain 2 items 20% and 1 item 5% if that makes scene.

F21 = Subtotal
F22 = VAT
F23 = Total Cost

Any guidance would be greatly appreciated.

Thank you in advance.